Russian Federation
Russian Federation
Due to the vast amount of information, the issue of optimizing database queries is becoming increasingly relevant. This review article will examine some scientific studies on SQL query optimization, optimization of database performance for PostgreSQL, as well as search optimization techniques in Oracle databases.
Oracle databases, SQL queries, optimization, database performance, query analysis
1. Barahnin V.B., Kozhemyakina O.Yu., Borzilova Yu.S. Optimizaciya SQL-zaprosov na primere raboty poiskovogo modulya sistemy kompleksnogo analiza hudozhestvennyh tekstov // Cloud of Science. – 2020. – T. 7, № 4. – S. 749-763.
2. Safin P.R., Vershinin E.V. Obzor metodov optimizacii bazy dannyh v SUBD PostgreSQL // Elektronnyy zhurnal: nauka, tehnika i obrazovanie. – 2023. – № 3 (43). – S. 17-22.
3. Gladkov A.K., Nikol'skaya D.I. Issledovanie poiskovoy optimizacii na osnove bazy dannyh Oracle // Ekonomika i kachestvo sistem svyazi. – 2022. – № 4 (26). – S. 67-74.
4. Novikova, T. P. Matematicheskaya model' intermodal'nyh gruzovyh perevozok / T. P. Novikova, S. A. Evdokimova, A. I. Novikov // Modelirovanie sistem i processov. – 2024. – T. 17, № 2. – S. 62-70. – DOIhttps://doi.org/10.12737/2219-0767-2024-17-2-62-70. – EDN ERRGGK.
