Assess students' ability to analyze and optimize SQL queries by interpreting execution plans, selecting and designing appropriate indexes, and choosing join strategies (nested loop, hash, merge) to improve performance; scope includes use of EXPLAIN/ANALYZE output, cardinality/selectivity, composite and covering indexes, index-only scans, statistics and cost trade-offs, and simple schema decisions (normalization vs. denormalization) for medium-complexity queries.