|
-
 Originally Posted by malay_biswal
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?
Finally, some good news at the end . Setting this hidden parameter has worked. Now, the query executes in 50 seconds.
I will test this setting for a period of two days before keeping it permanently.
lucky
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