Sql Tuning

 

There are 2 goals in Performance Tuning

• Reduce User Response time, i.e. decreasing the time between the user issues a statement and receives a response
• Improve throughput i.e. using the least amount of resources necessary to process all the rows access by the statement 

 

Following the same pattern as when we planned our vacation, we will accomplish everything according to the same time and distance. Sql Statementss also depends for two things: throughput and user response time.

 

 

Prequisites for Sql Training

• Familiarity with Database Architecture
  • That means how Sql stores the data how it retrieves the data and how it produces the result set.
• Kowledge of SQL
  • Understand how well that data can be joined to write a Perfect Sql.
  • You show know wither we have to create an index or a partition for fast retrieval of data. 
• Familiarity with SQL Tuning Tools
  • You may employ a variety of tweaking tools, such as explain plan, take a proof and a few programs, in order to detect the issue