Bitmap index or no index?

From: Michael Ray <topshot.rhit_at_gmail.com>
Date: Mon, 06 Apr 2009 16:24:07 -0400
Message-id: <49DA64E7.2060304_at_gmail.com>



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;

This is 10.2 with a couple million rows in the mfgunit table. The number of rows where backflushed is null will be very few FOR the records that match the join condition with the pumpdata table. Once the records that match this query are processed, backflushed is set for them. A process will regularly add new records that will match the query. Looking at the query I may add a bitmap on pumpdefectsid if it doesn't exist already since that only has 7 values I think.

--

Sincerely,
Michael Ray
--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 06 2009 - 15:24:07 CDT

Original text of this message