Query Processing and Optimization
|
Topic |
Link to slides |
Textbook chapters (3rd edition) | Suggested practice problems |
Read on your own (included for test) |
supplementary Reading (NOT included for test) |
|
Evaluation of relational operators |
chapter12.pdf 10/30/2023 |
Chap 12 |
12.2, 12.4, |
||
| Evaluation of relational operators (contd.) |
Chap 12, 14 |
14.2, 14.4, 14.6 | |||
| Hash join algorithms |
chap12-hash.pdf |
||||
|
Relational query optimization |
chapter15.pdf | Chap 15 |
15.2, 15.4, 15.6. 15.8 |
||
| Robust Query Optimization | Not included | ||||
| what is included for Test 3 | module-III-IV-summary(5).pdf | All of the above are included for Test 3 | Useful if you solve above problems |