Oracle 7.3.2 and bitmap indexes 
Author Message
 Oracle 7.3.2 and bitmap indexes

Hi.

 I am using Cost Based Optimizer with Oracle 7.3.2.3.
 When I execute
  SELECT * FROM tab_1
  WHERE <some conditions> AND
   status IN ( 1,5,8,9,11 );
 ( STATUS field has about 7-8 distinct values and BIT-MAP index
   is defined on that field ) - Optimizer ignores IN clause
  completly and display rows with status 2/3/etc.
 When I drop the bitmap index on status, or use
  status + 0 IN (1,5,8,9,11) - it work fine.

 Any suggestions, folks?

 Michael.

 P.S. I tried to find some info on Oracle.technet, but no go.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Oracle 7.3.2 and bitmap indexes

Quote:

> Hi.

>  I am using Cost Based Optimizer with Oracle 7.3.2.3.
>  When I execute
>   SELECT * FROM tab_1
>   WHERE <some conditions> AND
>    status IN ( 1,5,8,9,11 );
>  ( STATUS field has about 7-8 distinct values and BIT-MAP index
>    is defined on that field ) - Optimizer ignores IN clause
>   completly and display rows with status 2/3/etc.
>  When I drop the bitmap index on status, or use
>   status + 0 IN (1,5,8,9,11) - it work fine.

>  Any suggestions, folks?

>  Michael.

>  P.S. I tried to find some info on Oracle.technet, but no go.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

7.3.2.3 had some bugs in the optimiser (not necessarily bitmap index
related but definitely CBO related) where you could get rows back that
should not have been included.  I saw one recently with INDEX_DESC
causing all sorts of nasties...

7.3.3.5 seemed to be lowest jump we could make before the dramas
disappeared - the alternative being to delete the stats for this table
or use the RULE hint.

HTH
--
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"

"Some days you're the pigeon, and some days you're the statue."



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. why would Oracle require hint to use bitmap index? does not pick up unless hinted

2. B-Tree Index Vs Bitmap Index Question

3. B-Tree Index Vs Bitmap Index Question

4. Bitmap Indexes under Oracle 7.3.4.3.1 on HPUX 10.2

5. Is it true tha Oracle 8i has bugs with large tables and Bitmap indexes

6. Using bitmap indexes on Oracle 7.3

7. Bitmap Indexes and Oracle 8

8. Experience in bitmap index in Oracle 7.3

9. index Vs bitmap index

10. BitMap Index, OLTP, Oracle expert

11. Oracle doesn't want to use bitmap index on partitioned table

12. Oracle Bitmap Index


 
Powered by phpBB® Forum Software