Choose one of them
1. Query Optimizer Overview
Query Optimization Steps
*Be sure to address the question â€œWhat are the algorithm categories?â€
2. Algorithms Introduction
*Be sure to explain how the merge/sort algorithm works.
3. Select Algorithms – Simple
*Be sure to discuss Algorithms S1-S7.
4. Select Algorithms – Complex
*Be sure to discuss Algorithms S8-S11.
5. Join Operation Algorithms
*Be sure to explain Algorithms J1-J5
6. Optimization Techniques
*Be sure to discuss Cost vs. Heuristic based optimization