INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES
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...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Polish Association for Knowledge Promotion
2012-06-01
|
| Series: | Applied Computer Science |
| Subjects: | |
| Online Access: | http://acs.pollub.pl/pdf/v8n2/3_%20vol_8no_2_2012.pdf |
| Summary: | 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. |
|---|---|
| ISSN: | 1895-3735 2353-6977 |