RE: _gby_hash_aggregation_enabledúlse

Thanks Jonathan - I think you're right.  I tried again and this time
added a comment to the second execution of the query and sure enough, it
did switch to SORT GROUP BY.  Then I ran the original query again and it
continued to use the HASH GROUP BY so apparently the hidden parameter
won't prevent its use if it's already in the shared pool - it only
prevents it from being chosen at parse time.

By the way, the query I sent wasn't meant to generate a HASH GROUP BY
operation, it was meant to check the shared pool to see if there are
currently any plans loaded that are using the HASH GROUP BY.

Thanks again,
Brandon 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis
 

Try repeating your test with a comment in the text to make the before
and after versions of the query look different.





Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: