Re: Weird explain plan

From: <slavko.brkic_at_swisslife.ch>
Date: 17 Aug 2005 07:09:47 -0700
Message-ID: <1124287787.580166.261450@g47g2000cwa.googlegroups.com>

Thanks Maxim.
I actually tried with the "_b_tree_bitmap_plans" to FALSE. It avoided the bitmap conversion but still was really slow. I removed the hint and it is now fast. The reason we used the hint is not valid anymore as the optimizer uses the desired path.

I actually did not now that bitmap conversions were a valid path for the optimizer. I thought you had to have bitmap index in order to have a bitmap conversion.

Cheers Received on Wed Aug 17 2005 - 09:09:47 CDT