Indexes
REALLY important to speed up query processing time.
Suppose we have a relation
Person (name, SSN, age, city)
An index on SSN enables us to fetch a tuple
for a given SSN very efficiently (not have to scan the whole relation).
The problem of deciding which indexes to put on the relations is
very hard! (it’s called: physical database design).