Live briefing
Everything about Query plan
Sequence of steps used to access data in a SQL relational database management system
A query plan is a sequence of steps used to access data in a SQL relational database management system. This is a specific case of the relational model concept of access plans. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Query planA 5-minute orientation
- Skim a recent paper: Performance of 4 Pre-Trained Sentence Transformer Models in the Semantic Query of a Systematic Review Dataset on Peri-ImplantitisInfluential work since 2022
- Pick up a classic book: The politics of the body in Weimar GermanyThe most-reprinted book on the subject
- Read the landmark paper: Plan-structured deep neural network models for query performance predictionCited 144 times
- Go sideways: Prepared statementA closely related topic
- Go sideways: Query optimizationA closely related topic
📖 Definitions
Noun The sequence of steps used to execute a given query in a SQL-based database.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Plan-structured deep neural network models for query performance prediction
A Survey on Advancing the DBMS Query Optimizer: Cardinality Estimation, Cost Model, and Plan Enumeration
Database workload characterization with query plan encoders
A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies
An automatic clustering technique for query plan recommendation
Query optimization and execution plan generation in object-oriented data management systems
Efficiently approximating query optimizer plan diagrams
A Novel Adaptive Cuckoo Search for Optimal Query Plan Generation
🆕 Influential since 2022
Performance of 4 Pre-Trained Sentence Transformer Models in the Semantic Query of a Systematic Review Dataset on Peri-Implantitis
PARQO: Penalty-Aware Robust Plan Selection in Query Optimization
RelJoin: Relative-cost-based selection of distributed join methods for query plan optimization
Performance Evaluation of Query Plan Recommendation with Apache Hadoop and Apache Spark
ROME: Robust Query Optimization via Parallel Multi-Plan Execution
📚 Books worth reading
The politics of the body in Weimar GermanyCornelie Usborne · 1992
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Prepared statement In database management systems (DBMS), a prepared statement, parameterized statement, (not to be confused with parameterized query) is a feature where…
- Query optimization Query optimization is a feature of many relational database management systems and other databases such as NoSQL and graph databases. The query optimizer…
- View (SQL) In a database, a view is the result set of a stored query that presents a limited perspective of the database to a user. This pre-established query command…
- Join (SQL) A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation…
- Cursor (databases) In computer science, a database cursor is a mechanism that enables traversal over the records in a database. Cursors facilitate processing in conjunction…
- Microsoft SQL Server Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced…
- Database administration Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle…
- Apache Empire-db Apache Empire-db is a Java library that provides a high level object-oriented API for accessing relational database management systems (RDBMS) through…