Politehnika i dizajn, Vol. 4 No. 2, 2016.
Izvorni znanstveni članak
https://doi.org/10.19279/TVZ.PD.2016-4-2-09
MICROSOFT SQL SERVER QUERY OPTIMIZATIONS USING INDEXES
Mario Knok
; Tehničko veleučilište u Zagrebu, Zagreb, Hrvatska
Željko Kovačević
; Tehničko veleučilište u Zagrebu, Zagreb, Hrvatska
Sažetak
The content of this paper is to explain the structure of the Microsoft SQL Server database indexes so that database tables could be optimized in order to maximize the performace of the queries executed on those tables. Proper use of table indexes is one of the most important activities related to the database optimization, and this paper explains in detail of how the indexes are implemented in SQL Server. Using the knowlegde of this structure, along with a series of tests at the end of the paper will help to make general conclusions about best practices for the use of table indexes.
Ključne riječi
Hrčak ID:
192078
URI
Datum izdavanja:
13.5.2016.
Posjeta: 1.866 *