Re: Bitmap index or no index?

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 6 Apr 2009 16:29:42 -0700
Message-ID: <bf46380904061629o505a0bdak7d0cddeb02919f60_at_mail.gmail.com>

On Mon, Apr 6, 2009 at 1:24 PM, Michael Ray <topshot.rhit_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 06 2009 - 18:29:42 CDT