Sunday, January 23, 2011

Explain the Perfomance Tuning.


  • It is the Improved throughput in OLTP System or decrease response time in datawarehouse(DWH). It s like that how fast we get output of a query/transaction/page/form from one to another.
  • Tuning can be applied at
    Query level /Object level / Database level /Application level / System level
  • Tuning is mainly responsible for   
    Database designer, Database developer, Database administrator(DBA), Application developer, etc.