RE: bitmap indexes and rule based optimizer

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Wed, 12 Sep 2001 12:49:47 -0700
Message-ID: <F001.0038C318.20010912124632@fatcity.com>

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_at_usmint.        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    treas.gov>                   cc:                                   
                                    
                    Sent by:                     Subject:     RE: bitmap indexes and 
rule based optimizer                  
                    root_at_fatcity.com                                                   
                                    
                                                                                       
                                    
                                                                                       
                                    
                    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: Alex.Hillman_at_usmint.treas.gov

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: Walthour, Jon (GEAE, Compaq)
INET: Jon.walthour_at_ae.ge.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

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: Hillman, Alex
INET: Alex.Hillman_at_usmint.treas.gov

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:
INET: Prasada.Gunda1_at_hartfordlife.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