Tables indexing for various densities of SQL queries groups (example of Oracle 11g)
R. Boroński, Grzegorz Bocewicz · 2014
Commonly used commercial tools are based on a methodology that enables tables indexing for individual SQL queries. The article presents an original method, based on a genetic algorithm, for indexing tables for groups of queries in a relational database. Conducted experiments have shown that the use of indices for a group of queries can reduce the group execution time by 15% as well as can reduce the memory needs by 68-90%.