Pomiary Automatyka Robotyka nr 2/2013 135 Indexes driven mechanism for grouped SQL queries

Abstract: This paper discusses the problem of automatic minimi-zation of a response time for a database workload by a proper choice of indexes on production systems. 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. We also intro-duce genetic algorithm that we use in experimental test. Numeri-cal results are presented to show quality of the recommended approach