Optimization of nested SQL queries revisited
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Optimization of large join queries: combining heuristics and combinatorial techniques
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Query evaluation techniques for large databases
ACM Computing Surveys (CSUR)
Cost-based optimization for magic: algebra and implementation
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
An overview of query optimization in relational systems
PODS '98 Proceedings of the seventeenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Efficient mid-query re-optimization of sub-optimal query execution plans
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
On optimizing an SQL-like nested query
ACM Transactions on Database Systems (TODS)
Rule-based query optimization, revisited
Proceedings of the eighth international conference on Information and knowledge management
Optimization of queries with user-defined predicates
ACM Transactions on Database Systems (TODS)
Oracle High-Performance SQL Tuning
Oracle High-Performance SQL Tuning
Fundamentals of Database Systems
Fundamentals of Database Systems
A Taxonomy of Indexing Schemes for Parallel Database Systems
Distributed and Parallel Databases
Information Sciences—Applications: An International Journal
User-Optimizer Communication using Abstract Plans in Sybase ASE
Proceedings of the 27th International Conference on Very Large Data Bases
The Volcano Optimizer Generator: Extensibility and Efficient Search
Proceedings of the Ninth International Conference on Data Engineering
Join algorithm costs revisited
The VLDB Journal — The International Journal on Very Large Data Bases
Robust query processing through progressive optimization
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Performance analysis of "Groupby-After-Join" query processing in parallel database systems
Information Sciences—Informatics and Computer Science: An International Journal
Research in mobile database query optimization and processing
Mobile Information Systems
Mobile join operators for restricted sources
Mobile Information Systems
Safety, domain independence and translation of complex value database queries
Information Sciences: an International Journal
SQL/XML Performance Analysis of Parent/Ancestor Queries
ICCSA '08 Proceedings of the international conference on Computational Science and Its Applications, Part II
| Hi-index | 0.07 |
The query optimization phase in query processing plays a crucial role in choosing the most efficient strategy for executing a query. In this paper, we study an optimization technique for SQL-Nested queries using Hints. Hints are additional comments that are inserted into an SQL statement for the purpose of instructing the optimizer to perform the specified operations. We utilize various Hints including Optimizer Hints, Table join and anti-join Hints, and Access method Hints. We analyse the performance of various nested queries using the TRACE and TKPROF utilities which provide query execution statistics and execution plans.