Original scientific paper

https://doi.org/10.19279/TVZ.PD.2016-4-2-09

MICROSOFT SQL SERVER QUERY OPTIMIZATIONS USING INDEXES

Mario Knok ; Zagreb University of Applied Sciences, Zagreb, Croatia
Željko Kovačević ; Zagreb University of Applied Sciences , Zagreb, Croatia

Abstract

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.

Keywords

Hrčak ID:

192078

URI

https://hrcak.srce.hr/192078

Publication date:

13.5.2016.

Article data in other languages: croatian

Visits: 1.901 *