-
_push_join_predicate
Hi,
Is there any harm if I change the value of hidden parameter "_PUSH_JOIN_PREDICATE" to false in oracle 9i. Because my query is taking almost 45 min to get results if _PUSH_JOIN_PREDICATE=true and less than a min when _PUSH_JOIN_PREDICATE=false. I am changing the value of _PUSH_JOIN_PREDICATE in my session using alter session.
Please help, Maheshwar
-
Originally Posted by maheshwar
Hi,
Is there any harm if I change the value of hidden parameter "_PUSH_JOIN_PREDICATE" to false in oracle 9i. Because my query is taking almost 45 min to get results if _PUSH_JOIN_PREDICATE=true and less than a min when _PUSH_JOIN_PREDICATE=false. I am changing the value of _PUSH_JOIN_PREDICATE in my session using alter session.
Please help, Maheshwar
Instead of changing the underscore parameter, why don't you tune the SQL statement?
Tamil
-
You ought to be able to prevent the predicate push at the query level by one of two other methods
Either of these would be preferable to modifying the hidden parameter. Don't forget to document in the query why you have done this.
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
|