Query Optimization Techniques in Microsoft SQL …

← Back to document page

Database Systems Journal vol. V, no. 2/2014 33 Query Optimization Techniques in Microsoft SQL server Costel Gabriel CORL AN, Marius Mihai LAZ R, Valentina LUCA, Octavian Teodor PETRICIC University of Economic Studies, Bucharest, Romania 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 .

34 Query optimization techniques in Microsoft SQL Server Table 1.2. Running a 2 table join query With clustered index (execution time / query

  Microsoft, Technique, Server, Optimization, Query, Query optimization techniques in microsoft sql, Query optimization techniques in microsoft sql server