Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reg:bitmap conversion in explain plan

mafaizOct 13 2011 — edited Oct 13 2011
Hi,
I have a query which was taking long time than usual.
After analyzing the query and run explain plan for that, we have found the particular table go for an bit map conversion.
In my environment the oracle hidden parameter "_b_tree_bitmap_plans"=true.
But if i use no-index hint in my query the query looks normal,but plan shows that cost for the full table scan was quite high
If i use index the query takes long time,.
So how to recover from this issue.
But in my environment the management will not allow me to change the hidden parameter ("_b_tree_bitmap_plans") to false.
Kindly suggest me on this

Regards,
Faiz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2011
Added on Oct 13 2011
4 comments
747 views