To the question of improving the performance of the database with the optimal index of tables
The article considers the problem of increasing the performance of the relational database by indexing tables. The traditional approach to designing database indexes is based on known recommendations and techniques for analyzing the frequency of requests for independent query tables. The approach proposed in the article consists in clustering a set of requests for reading information and arranging indices for clusters, rather than independent queries.