Portal de Periódicos da CAPES

Query Optimization Techniques in Microsoft SQL Server

2014; Bucharest Academy of Economic Studies Publishing House; Volume: 5; Issue: 2 Linguagem: Inglês

2069-3230

Costel Gabriel Corlatan, Marius Mihai Lazar, Valentina Luca, Octavian Teodor Petricica,

Cloud Computing and Big Data Technologies

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.