rbo does not support bitmap indexes.
Alternate way (in case if you don't want to use alter session to change the
optimizer) to make use of the bitmap index is,
If you provide index hint with bitmap index in the SQL statement, It
invokes cbo and the bitmap index would be used for that particular query
execution.
We had the same requirement when we were using v7.3
hth
prasad
"Hillman, Alex"
<Alex.Hillman@usmint. To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
treas.gov> cc:
Sent by: Subject: RE: bitmap indexes and
rule based optimizer
[EMAIL PROTECTED]
09/12/2001 04:15 PM
Please respond to
ORACLE-L
Thanks. However bitmap indexes are 7.3+ feature - why I asked.
Alex Hillman
-----Original Message-----
Sent: Wednesday, September 12, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Alex:
No, the rbo does not support bitmap indexes or any other Oracle8 or greater
feature (such as partitioning, etc.). To use these features, you must set
optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the
cbo.
Jon Walthour
-----Original Message-----
Sent: Wednesday, September 12, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Anybody knows whether rule based optimizer can use bitmap indexes?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Walthour, Jon (GEAE, Compaq)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
