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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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