Re: optimizer won't pick bitmap index

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