presentation on performance tuning [message #19772] |
Tue, 09 April 2002 02:52 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
hello
i'm giving a presentation on performance tuning using sql statements. What are the topics i need to cover.
I've included topics like
indexes, hinnts, explain plan, tkprof, optimiser.
please help
|
|
|
Re: presentation on performance tuning [message #19776 is a reply to message #19772] |
Tue, 09 April 2002 06:14 |
uma
Messages: 67 Registered: May 2001
|
Member |
|
|
As I know TUNING is not an exact science. Tuning is a process of trail and error. You should use the tools like explain plan to assist you in this process, and try things like changing the order of the tables in the from clause during your tuning process.
Tks,
Uma
|
|
|