| hints !! [message #6844] |
Wed, 07 May 2003 22:57  |
wrbalaji
Messages: 11
Registered: February 2003
|
Junior Member |
|
|
Hi all,
I have a query having numerous joins.
Can any one tell me what HINT should i prescribe to increase my query performance?
thanks in advance,
balaji.
|
|
|
|
| Re: hints !! [message #6846 is a reply to message #6844] |
Thu, 08 May 2003 00:32  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
In most cases you won't need a hint. If you use the Cost Based Optimizer and have the proper indexes and you have recently analyzed your tables, it will look for the most performant execution path (in an ideal world of course, because sometimes it can be directed by hints).
Do an EXPLAIN PLAN of the statement to look at the execution path. Sometimes rebuilding the indexes might help.
If you have a tool like TOAD, you most probably have some sort of EXPLAIN PLAN tool which visualises the access path used by Oracle.
Tuning is a very elaborated subjectand in most cases simply adding hints won't increase performance.
See here for an overview of SQL*Tuning.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
