Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer won't pick bitmap index

Re: optimizer won't pick bitmap index

From: roobaron <member_at_dbforums.com>
Date: 30 Jul 2002 03:28:36 GMT
Message-ID: <3d4607e4$1@news.usenetgateway.com>


rule based optimiser does not recognise BITMAP indexes.

Try enabling choose at session level and see whether it sees it.

note: bitmaps will only get chosen if the cost is lower than

      another method

--
An Oracle DBAs undocumented init.ora parameters

_OVERCOME_POOR_DESIGN = TRUE
_DISABLE_BAD_PERFORMANCE = TRUE
Posted via dBforums http://dbforums.com
Received on Mon Jul 29 2002 - 22:28:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US