Indexes
REALLY important to speed up query processing time.
Suppose we have a relation
Person (name, social security number, age, city)
An index on “social security number” 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).