Search Results - SQL-query optimization

Logical and Physical Optimizations for SQL Query Execution over Large Language Models

Authors: Dario Satriani Enzo Veltri Donatello Santoro et al.

Source: Proceedings of the ACM on Management of Data. 3:1-28

STRATEGIES FOR IMPROVING THE PERFORMANCE OF RUBY WEB APPLICATIONS: DATA CACHING AND SQL QUERY OPTIMIZATION

Authors: Topalidi A.

Subject Terms: data caching, SQL query optimization, web application performance, Redis, Memcached, ActiveRecord, N+1 queries

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Authors: Nisuli Hettiarachchi Prasan Yapa

Source: 2025 5th International Conference on Machine Learning and Intelligent Systems Engineering (MLISE). :31-39

SQL query design and optimization: A study of joins, window functions, and recursive constructs

Authors: Mohanraju Muppala

Source: SQL Database Mastery: Relational Architectures, Optimization Techniques,and Cloud-Based Applications ISBN: 9789371851916

SPARK SQL QUERY OPTIMIZATION WITH REINFORCEMENT MACHINE LEARNING

Authors: Aakula, Ajay

SQL QUERY EXECUTION OPTIMIZATION ON SPARK SQL

Authors: I. Gankevich V. Korkhov G. Mozhaiskii

Source: 9th International Conference "Distributed Computing and Grid Technologies in Science and Education". :445-449

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Spark SQL Query Optimization Based on Runtime Statistics Collection

Authors: Yong Zhao Rong Chen

Source: 2021 IEEE 6th International Conference on Cloud Computing and Big Data Analytics (ICCCBDA). :250-255

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Artificial Intelligence-Based Performance Optimization of Oracle PL/SQL Queries ; Oracle PL/SQL Sorgularının Yapay Zekâ Tabanlı Performans Optimizasyonu

Authors: Gökhan TOPSAKAL Önder ŞAHİNASLAN

Source: ARCENG (INTERNATIONAL JOURNAL OF ARCHITECTURE AND ENGINEERING) ISSN: 2822-6895; Vol. 5 No. 2 (2025): ARCENG (INTERNATIONAL JOURNAL OF ARCHITECTURE AND ENGINEERING) ISSN: 2822-6895; 384-399 ; ARCENG (INTERNATIONAL JOURNAL OF ARCHITECTURE AND ENGINEERING) ISSN: 2822-6895; Cilt 5 Sayı 2 (2025): ARCENG (INTERNATIONAL JOURNAL OF ARCHITECTURE AND ENGINEERING) ISSN: 2822-6895; 384-399 ; 2822-6895

Subject Terms: Oracle, PL/SQL, Performance Optimization, AI, SQL Analysis, Performans Optimizasyonu, Yapay Zeka, SQL Analizi

File Description: application/pdf

Relation: https://e-arceng.com/index.php/arceng/article/view/76/58

Availability: https://e-arceng.com/index.php/arceng/article/view/76
https://doi.org/10.5281/zenodo.17992614

SQL Query Optimization in Distributed NoSQL Databases for Cloud-Based Applications

Authors: Aristeidis Karras Christos Karras Antonios Pervanas et al.

Source: Lecture Notes in Computer Science ISBN: 9783031334368

The Examination of SQL Queries Efficiency in Chosen IT System

Authors: Krzysztof Barczak

Source: Journal of Computer Sciences Institute, Vol 28 (2023)

Subject Terms: 03 medical and health sciences, 0302 clinical medicine, databases, SQL query optimization, Electronic computers. Computer science, 0202 electrical engineering, electronic engineering, information engineering, Information technology, QA75.5-76.95, 02 engineering and technology, performance analysis, T58.5-58.64, testing

Access URL: https://doaj.org/article/9a9200af262249c58ce6bd01fcedff74

An Approach to Aid Decision-Making by Solving Complex Optimization Problems Using SQL Queries

Authors: Jose Torres-Jimenez Nelson Rangel-Valdez Miguel De-la-Torre et al.

Source: Applied Sciences, Vol 12, Iss 9, p 4569 (2022)

Subject Terms: decision support system, combinatorial optimization, Three-Coloring Graph Problem, Portfolio Selection Problem, Maximum Clique Problem, SQL queries, Technology, Engineering (General). Civil engineering (General), TA1-2040, Biology (General), QH301-705.5, Physics, QC1-999, Chemistry, QD1-999

File Description: electronic resource

Relation: https://www.mdpi.com/2076-3417/12/9/4569; https://doaj.org/toc/2076-3417

Access URL: https://doaj.org/article/24b721cd913644309af6adff3bd81ff8

OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES

Authors: Dominika Hodun Maria Skublewska-Paszkowska

Source: Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska, Vol 7, Iss 3 (2017)

Subject Terms: queries, Environmental sciences, 0202 electrical engineering, electronic engineering, information engineering, Environmental engineering, GE1-350, 02 engineering and technology, TA170-171, optimization, Transact-SQL

Access URL: https://doaj.org/article/e24ac425aa894f5297a6ea766644c814

SQL Query Optimization Techniques

Authors: Priyanka R. Munot Dipali R. Patil Kajal P. Pathak

Source: IJARCCE. 8:87-90

Adaptive SQL Query Optimization in Distributed Stream Processing: A Preliminary Study

Authors: Darya Sharkova Alexander Chernokoz Artem Trofimov et al.

Source: Communications in Computer and Information Science ISBN: 9783030938482

Efficient Bi-objective SQL Optimization for Enclaved Cloud Databases with Differentially Private Padding: Efficient bi-objective SQL optimization for enclaved cloud databases with differentially-private padding

Authors: Yaxing Chen Qinghua Zheng Zheng Yan

Source: ACM Transactions on Database Systems. 48:1-40

Subject Terms: SQL queries, Data encryption (aspects in computer science), differential privacy, Database theory, Privacy of data, 0211 other engineering and technologies, 0202 electrical engineering, electronic engineering, information engineering, enclaved database, 02 engineering and technology, bi-objective parametric query optimization, trade-off between performance and privacy loss, SGX

File Description: application/xml

Access URL: https://zbmath.org/7884966
https://doi.org/10.1145/3597021

To rewrite or not to rewrite: Decision making in query optimization of SQL queries

Authors: Böhm, Daniela

Subject Terms: decision tree, conjunctive queries, decision procedure, query optimization, database systems

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH

Authors: Jurgita Lieponienė

Source: Taikomieji tyrimai studijose ir praktikoje, Vol 13, Iss 1, Pp 94-101 (2017)

Subject Terms: sql query, database index, normalization of the database, denormalization of the database, Social sciences (General), H1-99

File Description: electronic resource

Relation: https://ojs.panko.lt/index.php/ARSP/article/view/40/27; https://doaj.org/toc/2029-1280; https://doaj.org/toc/2669-0071

Access URL: https://doaj.org/article/0eab8f59551940b484092b3fa656c273

External optimization of SQL-query under conditions of databases structural uncertainty

Authors: M. Zagirnyak P. Kostenko

Source: 2016 17th International Conference Computational Problems of Electrical Engineering (CPEE). :1-4

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

SQL Query Optimization by Predicting Multiple Logical Plans with Machine Learning

Authors: Punter, Wieger R.

Index Terms: Master, Master

URL: https://pure.tue.nl/ws/files/305006245/Punter_W.pdf
https://pure.tue.nl/ws/files/305006245/Punter_W.pdf

A novel approach for SQL query optimization

Authors: Fazal Mithani Sahista Machchhar Fernaz Jasdanwala

Source: 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC). :1-4