| USE_HASH [message #364411] |
Mon, 08 December 2008 05:45  |
jageesh
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 ,
Jageesh
|
|
|
|
|
|
| Re: USE_HASH [message #364420 is a reply to message #364413] |
Mon, 08 December 2008 06:01  |
Frank Naude
Messages: 4580
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
