An Overview of SQL Optimization Techniques for Enhanced Query Performance
T. M. Hayath, K Usman, Mohammed Shafiulla, Dadapeer · 2023
According to recent trends, the size of databases is increasing rapidly, which calls for the need for larger databases that can be scaled to support future upgrades without compromising performance. Additionally, the way SQL queries are structured can have a significant impact on their execution performance. This paper proposes a set of rules for formatting SQL queries that must be followed to optimize them. The approach includes identifying any need for indexing on specific columns if the query includes filtration. By avoiding the unnecessary use of data and columns, our proposed model aims to convert user SQL queries into optimized ones, reducing query execution time which provides an in-depth analysis of SQL optimization techniques to enhance the performance of database queries. The research discusses the significance of query optimization and outlines some of the commonly used techniques in SQL optimization.