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?
Originally Posted by maheshwar
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.
Click Here to Expand Forum to Full Width