Bitmap Index problem...

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Mon, 15 Jan 2001 12:36:04 +0400
Message-Id: <10742.126638@fatcity.com>

Hi,
I have created a bitmap index on a table. The same query behaves differently under various optimisation modes, on 8.1.7 db

-desc am33

 Name                            Null?    Type
 ------------------------------- -------- ----
 COL1                                     NUMBER
 COL2                                     VARCHAR2(10)

-create bitmap index am33_col1 on am33(col1); Index created.

-select * from am33
2 where col1 = 1;

COL1 COL2
__________ __________

1 checking

I changed the optimisation mode and got the following results: RULE- full scan
CHOOSE - full scan
FIRST_ROWS - using bitmap index.
ALL_ROWS - full scan

I want to use the bitmap index for non-cost based db's. Any idea how to go about it?
Note: compatible set to 8.1.7

Thanks,
Amar Kumar Padhi
Software consultant Received on Mon Jan 15 2001 - 02:36:04 CST