RE: Bitmap Index problem...

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Tue, 16 Jan 2001 11:56:24 -0500
Message-Id: <10743.126802@fatcity.com>

The fact of the matter is that Oracle has stopped developing RBO with version 7.2.
Any new feature after that does not work with RBO. It applies to partitions, hash joins,
bitmap indexes, function based indexes, staq query etc.

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

From: Libal, Ivo [mailto:ivo.libal_at_knapp-systems.com] Sent: Tuesday, January 16, 2001 4:05 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Bitmap Index problem...

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

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

Sent: Tuesday, January 16, 2001 9:05 AM
To: Multiple recipients of list ORACLE-L

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

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 Received on Tue Jan 16 2001 - 10:56:24 CST