Analysis of current trends in relational database indexing
Michal Kvet, Karol Matiaško · 2020
Database management is currently an inevitable part of information technology. It requires data to be obtained in a fast, reliable, and consistent manner. Indexes are defined as an optional structure to improve Select statement performance. On the other hand, they cause additional demands, if data are changed, whereas such change must be reflected in the index, as well. This paper aims to discuss the auto-indexing methods provided by DBS Oracle, highlighting their limitations. We propose own techniques to remove the impact of peaks caused by adding new queries to the system, to which no suitable index is present. It is based on the block data analysis in the pointer layer.