EconPapers    
Economics at your fingertips  
 

Query Optimization Techniques in Microsoft SQL Server

Costel Gabriel Corlăţan (), Marius Mihai Lazăr (), Valentina Luca () and Octavian Teodor Petricică ()
Additional contact information
Costel Gabriel Corlăţan: University of Economic Studies, Bucharest, Romania
Marius Mihai Lazăr: University of Economic Studies, Bucharest, Romania
Valentina Luca: University of Economic Studies, Bucharest, Romania
Octavian Teodor Petricică: University of Economic Studies, Bucharest, Romania

Database Systems Journal, 2014, vol. 5, issue 2, pages 33-48

Abstract: Microsoft SQL Server is a relational database management system, having MS-SQL and Transact-SQL as primary structured programming languages. They rely on relational algebra which is mainly used for data insertion, modifying, deletion and retrieval, as well as for data access controlling. The problem with getting the expected results is handled by the management system which has the purpose of finding the best execution plan, this process being called optimization. The most frequently used queries are those of data retrieval through SELECT command. We have to take into consideration that not only the select queries need optimization, but also other objects, such as: index, view or statistics.

Keywords: SQL Server; Query; Index; View; Statistics; Optimization (search for similar items in EconPapers)
Date: 2014
References: View complete reference list from CitEc
Citations Track citations by RSS feed

Downloads: (external link)
http://dbjournal.ro/archive/16/16_4.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: http://EconPapers.repec.org/RePEc:aes:dbjour:v:5:y:2014:i:2:p:33-48

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Series data maintained by Adela Bara ().

 
Page updated 2016-12-23
Handle: RePEc:aes:dbjour:v:5:y:2014:i:2:p:33-48