Home » RDBMS Server » Performance Tuning » USE_HASH (Oracle 9i)
USE_HASH [message #364411] Mon, 08 December 2008 05:45 Go to next message
Messages: 1
Registered: April 2007
Junior Member
Hi ,

I had a select Query for creating a view . Query is using SQL hint USE_HASH.Now the query is taking long hours to execute as compared to usual scenorios ie around to 5 to 10 minutes.
Is there any issues in using use_hash hint or in indexing . Can anyone , suggest me about details in using use_hash hint.

Thanks ,

Re: USE_HASH [message #364413 is a reply to message #364411] Mon, 08 December 2008 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know what a hint is for and what it leads to, remove it.

Re: USE_HASH [message #364420 is a reply to message #364413] Mon, 08 December 2008 06:01 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
I agree with Michel. Oracle normally knows which access method will be the fastest (based on stats gathered). Hint should only be used if you think Oracle made a mistake and you know a better access method.
Previous Topic: how to tune this query?
Next Topic: INDEX_DESC Hint
Goto Forum:

Current Time: Sun Oct 23 19:18:42 CDT 2016

Total time taken to generate the page: 0.07807 seconds