_push_join_predicate
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: _push_join_predicate

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    _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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote 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

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width