Oracle 7.3.2 and bitmap indexes

From: <michael_bialik_at_my-deja.com>
Date: Sat, 23 Oct 1999 22:33:15 GMT
Message-ID: <7utd3c$9t9$1@nnrp1.deja.com>

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. Received on Sat Oct 23 1999 - 17:33:15 CDT