- 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.