QUERY OPTIMIZATION IN RELATIONAL DATABASES

Conde Abdul Karim

This article discusses query optimization technologies in relational databases. The purpose of this article is to optimize the query structure in relational databases when processing large amounts of information. As a result of the work, the main provisions were developed in the form of the results of the analysis of technologies for improving database performance using indexing technologies, methods for optimizing the database structure to improve performance, using the identification of bottlenecks and problematic queries, as well as monitoring and testing database performance.

Keywords:query optimization, relational database, indexing, stored procedures, database performance monitoring