The performance optimization of database systems has been widely studied for years. From
the perspective of the operation and maintenance personnel, it mainly includes three topics …

This paper introduces the concept of letting an RDBMS optimizer optimize its own
environment. In our project, we have used the DB2 optimizer to tackle the index selection …

Database administrators (DBAs) play a crucial role in managing, maintaining and optimizing
a database system to ensure data availability, performance, and reliability. However, it is …

Indexes are essential for the efficient processing of database workloads. Proposed solutions
for the relevant and challenging index selection problem range from metadata-based simple …

Index tuning aims to find the optimal index configuration for an input workload. It is a
resource-intensive task since it requires making multiple expensive" what-if" calls to the …

Self-tuning is a feature of autonomic databases that includes the problem of automatic
schema design. It aims at providing an optimized schema that increases the overall …

Well-chosen secondary indexes are highly relevant for database performance. For complex
workloads, current index selection algorithms are either not fast or not highly competitive …

The rapidly increasing volume of information contained in relational databases places a
strain on databases, performance, and maintainability: DBAs are under greater pressure …

Index tuning plays a crucial role in facilitating the efficiency of data retrieval within database
systems, which adjusts index settings to optimize the database performance. Recently, with …

Database administrators (DBAs) play an important role in managing, maintaining and
optimizing database systems. However, it is hard and tedious for DBAs to manage a large …