Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries
Abstract: SQL statements can be used to retrieve data from any database. If you've worked with databases for any amount of time retrieving information, it's practically given that you've run into slow running queries. Sometimes the reason for the slow response time is due to the load on the system, and other times it is because the query is not written to perform as efficiently as possible which is the much more common reason. For better performance we need to use best, faster and efficient queries. This paper covers how these SQL queries can be optimized for better performance. Query optimization subject is very wide but we will try to cover the most important points. In this paper I am not focusing on, in- depth analysis of database but simple query tuning tips & tricks which can be applied to gain immediate performance gain.
 10 Ways to Improve SQL Query Performance http://www.developer.com/db/10-ways-to-improve-sql-query-performance.html
 15 Ways to Optimize Your SQL Queries http://hungred.com/useful-information/ways-optimize-sql-queries/
 Optimize SQL Server queries with these advanced tuning techniques. http://www.techrepublic.com/blog/the-enterprise-cloud/optimize-sql-server-queries-with-these-advanced-tuning-techniques/.
 Making Queries Run Faster https://sqlschool.modeanalytics.com/advanced/faster-queries.html.
 Query Optimization Techniques in Microsoft SQL Serverhttp://www.dbjournal.ro/archive/16/16_4.pdf
 SQL Tuning or SQL Optimization. http://beginner-sql-tutorial.com/sqlquery-tuning.htm
 SQL Server Optimization Tips.http://santhoshgudise.weebly.com/uploads/8/5/4/7/8547208/sql_server_optimization_tips-1.doc
 Efficient SQL Statements https://oracle-base.com/articles/misc/efficient-sql-statements
 Best Way to Write SQL Query. http://www.ifadey.com/2010/11/best-way-to-write-sql-query/
 SQL Tuning Guidelines for Oracle - Simple yet Effective! http://askanantha.blogspot.com/2007/10/sql-tuning-guidelines-for-oracle-simple.html
 What are the most common SQL Optimizations. http://stackoverflow.com/questions/1332778/what-are-your-most-commonsql-optimizations
 Top 10 performance tuning tips for relational databases. http://web.synametrics.com/top10performancetips.htm