|
-
You can set this in session level and execute to see if bitmap conversion is happening.
_b_tree_bitmap_plans = false
However i think problem is with NL join, did you try excuting query with FULL hint?
This "LOWER(CONVERT('%813982%','WE8MSWIN1252','WE8MACROMAN8')))" is where it is doing bitmap conversion 367018 many times, so lets c after setting _b_tree_bitmap_plans = false what's happening.
BTW, how long it was taking to execute before and what changes done after which this query taking long time?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote