How to push Hash Anti join without HINT or code modification ? [message #217929] |
Tue, 06 February 2007 02:30 |
deadpoet69
Messages: 3 Registered: August 2006
|
Junior Member |
|
|
Dears,
I'm facing a problem.
(Oracle 9.2.0.7)
An execution plan shows that a query want to do a Nested Anti Join. By placing an Hint "/*+ hash_aj */, it runs much faster.
But .. there's a good but ...
1- We are not the owner of the code, so we can't modify it or add an Hint.
2- We don't want to put the "always_anti_join"'s parameter to "HASH" because , we just want to tune 1 query and not all the database's queries.
3- The objects used for this query are synonyms of views. I don't know how to handle stats on that.
4- They are no bind variable in this SQL. All changing parameters pass as hard coded. So how can I use OUTLINES ?
So the question is , how can I tell Oracle to use an Hash Anti Join instead of the Nested Anti join ?
I'm puzzled ...
Many thanks to anyone who has spent little time , first for reading this.
|
|
|
|