| Can anyone do the guidance to learn Performance Tuning? [message #165556] |
Thu, 30 March 2006 22:30  |
srivishnuhari
Messages: 5
Registered: January 2006
Location: Chennai
|
Junior Member |
|
|
Hi,
Am new one step into Performance Tuning.
Can anyone do the guidance to learn Performance Tuning?
Am eager to learn and would like to deliver perfect query to satisfy the customer requirement.
Can anyone give your hand to lift me?
Am expecting needful help regarding this.
Thanks in Advance.
|
|
|
|
| Re: Can anyone do the guidance to learn Performance Tuning? [message #165560 is a reply to message #165556] |
Thu, 30 March 2006 22:56  |
sharan_it
Messages: 140
Registered: July 2005
Location: Chennai
|
Senior Member |
|
|
Only experience can help u..
Becoz performance tuning depends on
1) size of tables
2) number of rows returned by the queries i.e inner query and outer query..
3) which methodology u r using..its is suits better..are u using suitable operators...
4) need to remove garbage codes which usually hits the performance
5) Is it nessary to use index..it yes means which type u r using..is it suitable..
6) what type of join u r using...
7) u can watch explain_plan also..before that u need to know what are the factors considered..
As a Senier Member, I suggest u try urself if u have any doubts or clarifications..first do the search whether similar forums are poster earlier and see that..Lots of forums available..
Still ur problem is not solved create a new forum..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
