Database Performance Tuning
Database performance tuning encompasses the steps you can take to optimize performance with the goal of maximizing the use of system resources for greater efficiency. By fine-tuning certain database elements such as index use, query structure, data models, system configuration, and application design, you can significantly impact the overall performance of your application.
With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done.