Comp 305-001/488-305: Database Administration
Spring 2016: Tuesdays, 4:15-6:45, Corboy L08
Week 11
April 5, 2016
Read in Elmasri & Navathe (EN). Chapters are labeled (7th edition)/(6th
edition)
Explain and
hash joins
Postgres likes hash joins. For hash joins, the presence of
indexes does not matter.
Explain and nested
queries
Index creation
Example where Postgres query plans depend on available indexes?
Normalization