RE: Bitmap Index problem...

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Tue, 16 Jan 2001 10:10:36 +0100
Message-Id: <10743.126743@fatcity.com>

The rule based optimizer does not support bitmapped indexes see:note:1079306.6 on metalink
Ivo Libal

-----Original Message-----

From: Amar Kumar Padhi [mailto:TS2017_at_emirates.com] Sent: Tuesday, January 16, 2001 9:05 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Bitmap Index problem...

Sorry, didn't work with hint either.
I tried with and without statistics also. Our system is rule based.
Any other idea?

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----

Sent: Monday, January 15, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L

Hi Amar,

How about using a hint to force the use of the index? You could do something like:

select /*+ INDEX(am33_col1) */ * from am33

where blah blah....

This then forces this index to be used..

HTH Mark

-----Original Message-----

Padhi
Sent: Monday, January 15, 2001 08:35
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Amar Kumar Padhi
INET: TS2017_at_emirates.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Amar Kumar Padhi
INET: TS2017_at_emirates.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message