INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES

Print

ABSTRACT

This paper discusses the problem of minimizing the response time for a given database workload by a proper choice of indexes. The main objective of our contribution is to illustrate the database queries as a group and search for good indexes for the group instead of an individual query. We present queries block relation conditions for applying the concept of grouped queries index selection. In three experimental tests we provide measurements on the quality of the recommended approach.

FULL TEXT