Continuous Online Index Tuning in Moving Object Databases
Source: National University of Singapore
Database tuning is crucial to the efficient operation of a DataBase Management System (DBMS). In fact, most commercial DBMS provides some tuning tools. The goal of tuning is to ensure the database system always operates in a near "Optimal" state. Variations in workload, including both queries and updates, can significantly impact the performance of the database. Usually, some components of the database, such as indexes and the query optimizer, can be configured to adapt to workload changes.