Guang,
One of the problems with 8 - 9 is that there are quite a few 'hidden'
parameters that are introduced or have different default values. One of these
_b_tree_bitmap_plans may be causing the problem. I'm not 100% on this
(Wolfgang Breitling is the man to provide the definitive answer), but it
I've just posted the answer to this question at the
comp.databases.oracle.server newsgroup !!
Here it is again.
If you look closely at the execution plans, they're performing a BITMAP
CONVERSION rather than using bitmap indexes per se. This where Oracle
converts btree indexes to bitmaps on the
Thanks. It is working now after I made the change.
Guang
On Wed, 22 Oct 2003, Richard Foote wrote:
I've just posted the answer to this question at the
comp.databases.oracle.server newsgroup !!
Here it is again.
If you look closely at the execution plans, they're performing a BITMAP