1. Science
  2. Publications
  3. Scientific Works of Kharkiv National Air Force University
  4. 3(57)'2018
  5. Investigation of the influence of use of indexes in tables relational databases

Investigation of the influence of use of indexes in tables relational databases

S. Minukhin, V. Viunenko
Annotations languages:


Description: Influence of structure of tables of the database of Microsoft SQL Server on the speed of execution of requests to these tables and also influence of use of indexes on the speed of execution of requests of data selecting is probed. The research was executed locally. For creation and control of databases Microsoft Server 2016 and the environment SQL Server Management Studio to manage SQL Server and also the SQLQueryStress program for the analysis of execution of requests was used. For check of productivity when adding data in the table with clustered by the index and without (in the clustered table and a heap) the database with two test tables, one of which has primary key on the basis of the clustered index, was created, and in the second primary key it is created by means of non-clustered index and the table represents a heap. The research included execution of delete queries and adding of records in tables and also execution of requests of data selecting. The received results are presented in the form of the table in which indices of monitoring of activity. Also for evident display of results diagrams are constructed. Two databases which are models of typical databases for trade enterprises, with identical structure and the different size were developed for a research of influence of use of indexes for tables of the database on productivity of execution of requests of selection. By results of a research recommendations for increase in productivity of execution of requests of adding, deleting and data selecting are defined. Results of a research can be used for further development of the database with use of indexes for receiving good performance measures of execution of requests.


Keywords: database, indexing, clustered index, non-clustered index, clustered table, heap, query performance

Reference:
 Minukhin, S.V. and Viunenko, V.Yu. (2018), “Doslidzhennia vplyvu vykorystannia indeksiv v tablytsiakh reliatsiinykh baz danykh” [Investigation of the influence of use of indexes in tables relational databases], Scientific Works of Kharkiv National Air Force University, Vol. 3(57), pp. 127-133. https://doi.org/10.30748/zhups.2018.57.19.