Technical gazette, Vol. 28 No. 4, 2021.
Original scientific paper
https://doi.org/10.17559/TV-20200121134626
Techniques for Ensuring Index Usage Predictability in Microsoft SQL Server
Blerta Haxhijaha Emini*
; South East European University, Ilindenska 335, Tetovo, 1220, Republic of North Macedonia
Jaumin Ajdari
; South East European University, Ilindenska 335, Tetovo, 1220, Republic of North Macedonia
Bujar Raufi
; South East European University, Ilindenska 335, Tetovo, 1220, Republic of North Macedonia
Besnik Selimi
; South East European University, Ilindenska 335, Tetovo, 1220, Republic of North Macedonia
Abstract
The demand for carrying out high-performance operations with data is growing in parallel with the vast growth of data itself. The retrieval of data for analysis, the manipulation of data, as well as its insertion in data stores must all be performed very efficiently, using techniques that ensure speed, reliability and accuracy. This paper investigates the techniques and practices that improve the performance of data retrieving by the use of SQL and Microsoft SQL Server. Being that SQL is a declarative language that specifies what should be produced as a result, instead of how to achieve that result, this paper will look at the internals of SQL Server that affect the "how" of queries and data operations, in order to propose techniques that ensure performance gains. The paper will aim to shed light on the limitations and variance in index usage, and to answer the question why indexes are sometimes used, and other times not, for the same query. To overcome the index limitations the "index fusion" technique is proposed.
Keywords
database; indexes; index fusion; SQL
Hrčak ID:
260800
URI
Publication date:
22.7.2021.
Visits: 1.710 *