Open AccessIndeksowanie tabel dla różnych gęstości grup zapytań SQL (na przykładzie Oracle 11g)
Author(s) -
R. Boroński,
Grzegorz Bocewicz
Publication year - 2014
Publication title -
digital library of the silesian university of technology (silesian university of technology)
Language(s) - English
Resource type - Journals
ISSN - 1731-2264
DOI - 10.21936/si2014_v35.n2.675
Subject(s) - computer science , pl/sql , database , world wide web , web search query , search engine , query by example
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%.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom