Construcción de un marco de referencia para la optimización de consultas en SQL

Abstract

Abstract: Optimizing SQL statements to improve the database engine's performance can take a great deal of time, if not days. That is why it is crucial to define a reference framework for query optimization, where anyone interested in designing SQL queries can learn about good practices to optimize the use of clauses within the different database managers. Based on what has been specified, the objective will be to propose a reference framework for constructing queries in SQL language by using good practices embedded in database management processes. In addition to designing a web application where various end-users can access and view the frame of reference. The investigation's main result is that the most significant number of errors during the creation of SQL statements occurs in the clauses immersed within the conditional WHERE, since the misuse of these clauses affects the databases' efficiency.