Summary: March 23, 2008 Databases: Query Proc. & Opt. 1
Query Processing and Optimization
March 23, 2008 Databases: Query Proc. & Opt. 2
Objectives
Introduction +
Major Phases in Query Processing +
Optimizing Queries +
Steps in Query Optimization +
Query Trees and Graphs +
Relational Algebra Transformation +
Query Processing and Optimization +
March 23, 2008 Databases: Query Proc. & Opt. 3
- Introduction
With declarative languages such as SQL, the user
specifies what data is required rather than how it is
retrieved
Relieves user of knowing what constitutes a good
execution strategy
Also gives the DBMS more control over system
performance.

Source: Adam, Salah - Department of Information and Computer Science, King Fahd University of Petroleum and Minerals

Collections: Computer Technologies and Information Sciences