Theoretical (and lab.) class on indexes

6 Março 2014, 11:44 Helena Galhardas

Tomorrow, we'll talk about indexes in the theoretical and lab classes.

Students should recapitulate what they've learnt in the Databases course about indexes, in particular what are they for, clustered vs unclustered indices, dense vs sparse indices, index-only plans, composite search keys, B+ trees, and hash-based indexes.

The guide for lab 2 is on-line, so students should also read and try so solve the exercises.