Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries
Jean de la Croix Habimana · International journal of scientific and technology research · 2015
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, indepth analysis of database but simple query tuning tips & tricks which can be applied to gain immediate performance gain. ————————————————————