PLAN DIAGRAMS: Visualizing Database Query Optimizers

Provided by: Indian Institute of Science
Topic: Data Management
Format: PDF
The automated optimization of declarative SQL queries is a classical problem that has been diligently addressed by the database community over the last few decades. However, due to its inherent complexities and challenges, this area has largely remained a "Black art" and the quality of the query optimizer continues to be a key differentiator between competing database products, with large research and development teams involved in their design and implementation. Over the past five years, the authors have provided a fresh perspective on the behavior of modern query optimizers through the introduction and development of the "Plan diagram" concept.

Find By Topic