Applied Computer Science (Jun 2012)

INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES

  • Radosław BOROŃSKI

Journal volume & issue
Vol. 8, no. 2
pp. 3 – 21

Abstract

Read online

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.

Keywords