When temporary results meet intermediate index: An optimization technique of procedural SQL query processing
Authors:
- Md Arif RahmanMRMd Arif Rahman
- Syed Jalaluddin HashmiSHSyed Jalaluddin Hashmi
- Kethsiya GnanajothyKGKethsiya Gnanajothy
- Young-Koo LeeYLYoung-Koo Lee
- 11 February 2026
- journal article
- Published by Elsevier in Data & Knowledge Engineering
- Vol. 164
Abstract
No abstract availableFunding Information
- Institute for Information and Communications Technology Promotion
- Ministry of Science and ICT, South Korea (RS-2022-00155911)
This publication has 18 references indexed in Scilit:
- Automatic index selection with learned cost estimatorInformation Sciences, 2022
- Join optimization for inverted index technique on relational database management systemsExpert Systems with Applications, 2022
- Bao: Making Learned Query Optimization PracticalACM SIGMOD Record, 2021
- Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates2020
- Iterative Query Processing based on Unified Optimization Techniques2019
- Automatically Indexing Millions of Databases in Microsoft Azure SQL Database2019
- PANENE: A Progressive Algorithm for Indexing and Querying Approximate k-Nearest NeighborsIEEE Transactions on Visualization and Computer Graphics, 2018
- FroidProceedings of the VLDB Endowment, 2017
- Extracting Equivalent SQL from Imperative Code in Database Applications2016
- AutoAdmin “what-if” index analysis utilityACM SIGMOD Record, 1998