Creating Indexes

CREATE INDEX ssnIndex ON Person(SSN)

Indexes can be created on more than one attribute:

CREATE INDEX doubleindex ON

Person (age, city)

Why not create indexes on all the attributes?

Previous slide

Next slide

Back to first slide

View graphic version