|
INTERNATIONAL JOURNAL OF INNOVATIONS IN APPLIED SCIENCES & ENGINEERINGInternational Peer Reviewed (Refereed), Open Access Research Journal (By Aryavart International University, India) E-ISSN:2454-9258 | P-ISSN:2454-809X | Estd Year: 2015 Impact Factor(2021): 5.246 | Impact Factor(2022): 5.605 |
Padmaja Pulivarthy
Vol. 8, Jan-Dec 2022
Page Number: 139 - 155
Abstract:
Database sizes are increasing, according to recent trends; therefore, larger databases that can be expanded for improvements in the future without sacrificing performance are required. The way SQL queries are structured has a significant impact on how well they execute. A set of formatting guidelines is presented in this document to optimise SQL queries. As part of our methodology, we determine whether the query requiring filtration requires indexing particular columns. Our suggested methodology seeks to optimise user SQL queries and reduce query execution time by minimising excessive use of data and columns. This study covers the importance of query optimisation and popular approaches and thoroughly reviews SQL optimisation strategies to improve database query efficiency.