Citations


Contact Us

For Marketing, Sales and Subscriptions Inquiries
Rockefeller Center, 45 Rockefeller Plaza
20th Flr Unit #5, New York, NY 10111
United States

Conference List

Review of Information Engineering and Applications

December 2014, Volume 1, 2, pp 66-76

Analytical Review of SQL Server Optimization

Gaurav Kumar

,

Arun Sangwan

Gaurav Kumar 1 ,

Arun Sangwan 1 
  1. Department of Information Technology, Panipat Institute of Engineering & Technology, Haryana, India 1

on Google Scholar
on PubMed

Pages: 66-76

DOI: 10.18488/journal.79/2014.1.2/79.2.66.76

Share :


Abstract:

It is a complex task to optimize query as well as to validate the correctness and effectiveness of query optimizer. A query optimizer should estimate and compare the costs of executing a query using different execution strategies and should choose the strategy with the lower cost estimate. To fairly and realistically compare different strategies accurate cost estimation is required. This is a challenging task to measure quality of query optimization as modern query optimizers provide more advanced optimization strategies and adaptive techniques. This paper describes different ways to improve the performance of SQL Server queries, index optimization with occasional references to particular SQL code and how to achieve the best performance for the given tables and queries by giving some tips for query optimization in Microsoft SQL Server. The paper provides a detailed overview of query optimization, Optimization techniques, testing of optimization techniques that are used to validate the query optimizer of Microsoft’s SQL Server and issues in query optimization testing.
Contribution/ Originality

Keywords:


Reference:

  1. Leo Giakoumakis, "Cesar Galindo-Legaria – testing SQL server’s query optimizer: Challenges, techniques and experiences," IEEE Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, pp. 1-8, 2008.
  2. Gennady Antoshenkov, "Dynamic query optimization in Rdb/VMS," in Proc. of IEEE 9th International Conference on Data Engineering, 1993, pp. 538-547.
  3. SQL Server Optimization Rips for Designing Tables by Alexander Chigrik http://www.databasejournal.com/features/article.php/3593466/MS-SQL-Series.htm.
  4. Navathe, Elmarsi, Somayajulu, and Gupta, Fundamentals of database systems, 6th ed.: Pearson Education, 2010.
  5. L. Kollar, "Statistics used by the query optimizer in microsoft SQL server 2000." Available: http://technet.microsoft.com/en-us/library/aa902688(v=sql.80).aspx.
  6. Ivan Bayross, SQL, PL/SQL the programming language of Oracle: BPB Publications, 2010.
  7. Z. Qiang, L. Per-Ake, Z. DeQiang, and L. Per-Ake, "Establishing a fuzzy cost model for query optimization in a multidatabase system," IEEE, pp. 1060-3425194, 1994.
  8. Introducing SQL Trace, Available: http://technet.microsoft.com/en-us/library/ms191006.aspx.
  9. K. Lubor, "Microsoft SQL 2000 technical articles, statistics used by the query optimizer in microsoft SQL server 2000." Available: http://msdn2.microsoft.com/en-s/library/aa902688(SQL.80).aspx.
  10. MSDN Blogs, "Tips, tricks, and advice from the SQL server query optimization team." Available: http://blogs.msdn.com/queryoptteam/default.aspx.
  11. Helios Solutions, "SQL query optimization and performance tuning." Available: http://blog.heliossolutions.in/sql-query-optimization-and-performance-tuning/.
  12. SQL Server Optimization Tips http://santhoshgudise.weebly.com/uploads/8/5/4/7/8547208/sql_server_optimization_tips-1.doc.
  13. "Optimization tips for designing tables." Available: http://www.mssqlcity.com/Tips/design_optimization.htm.

Statistics:

Google Scholor ideas Microsoft Academic Search bing Google Scholor

Funding:

Competing Interests:

Acknowledgement:


Related Article