Re: Bitmap index or no index?

On Mon, Apr 6, 2009 at 1:24 PM, Michael Ray <topshot.rhit@xxxxxxxxx> wrote:

> For the following query should I bother with a bitmap index on backflushed
> or just go without an index?
> select replace(p.item_no, '-'), count(*)
> from pumpdata pd, part p, mfgunit m
> where pd.mfgunitid = m.mfgunitid and m.backflushed IS NULL
>  and pd.partid = p.partid and pd.pumpdefectsid=0
> group by p.item_no
> order by 2;

Let's back up a step.

Why are you even looking at it?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: