Query Optimization
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What does Query Optimisation mean?
2. What are the three phases of query processing?
3. During the Parsing and Translation phase, what does the parser do with a SQL query?
4. After parsing, into what form is a SQL query converted before optimisation?
5. What structure is usually built from the relational algebra expression for the optimisation engine to analyse?
6. Which two kinds of optimiser does Oracle use?
7. What does the Teradata optimiser rely on to decide how best to access, join and aggregate tables?
8. How does the SQL Server optimiser choose an execution plan?
9. What is the final step of query processing once the best execution plan has been selected?
10. What is described as the core capability of Query Optimisation?