Tuning SQL Queries for Better Performance
DOI:
https://doi.org/10.61841/5sd23y66Keywords:
Structured Query Language, Tuning, PerformanceAbstract
Structured Query Language (SQL) statements are used to retrieve data from the database. We can get the same results by writing SQL queries in a different way. But use of the best query is important when performance is considered. So we need SQL query tuning based on the business and user requirements. This paper is focusing on simple query tuning tips & tricks that can be applied to gain better performance.
Downloads
References
[1] Shalabh Mehrotra-Senior Solutions Architect—SQL Performance Tuning
[2] Navita Kumari, SQL Server Query Optimization Techniques - Tips for Writing Efficient and Faster Queries, International Journal of Scientific and Research Publications, Volume 2, Issue 6, June 2012.
[3] Oracle Performance Tuning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande and John Kostelac
[4] Oracle 9I Documentation
[5] SQL Server 7.0 Query Processor
[6] Dean Richards, Manager Sales Engineering, Senior DBA-SQL Query Tuning for SQL Server Index Tuning Wizard for SQL Server 7.0
[7] http://docs.oracle.com/html/A86647_01/vmqtune.htm
[8] http://www.dba-oracle.com/art_sql_tune.htm
[9] https://technet.microsoft.com/en-us/library/ms172984(v=sql.110).aspx
[10] http://www.dba-village.com/dba/village/dvp_papers.Main?CatA=45
[11] http://sqlmag.com/database-performance-tuning/sql-server-white-papers
Downloads
Published
Issue
Section
License
Copyright (c) 2020 AUTHOR
This work is licensed under a Creative Commons Attribution 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
