Transcription of Query Optimization Techniques in Microsoft SQL Server
{{id}} {{{paragraph}}}
Example: air traffic controller
Query Optimization Techniques in Microsoft SQL Server
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 . 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.
Microsoft SQL Server is a relational database management system, having MS-SQL and Transact-SQL as primary structured programming languages. They rely on relational
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
ReportPortal Web Reporting for Microsoft SQL Server, Microsoft SQL Server Analysis, SQL Server Analysis, Cube in Analysis Services Step by Step, Analysis, Microsoft, Server, MDXandDAX, Microsoft SQL Server, MDX and DAX, SQL Server 2012 UNLEASHED, SQL Server, SQL Server Forensics, Database Forensics, Tutorials for Project on Building a Business Analytic, Text Mining, Structured Query Language, Microsoft SQL Server 2014 Licensing Guide