Creating Indexes

CREATE INDEX ssnIndex ON Person(social-security-number)

Indexes can be created on more than one attribute:

CREATE INDEX doubleindex ON

Person (name, social-security-number)

Why not create indexes on everything?

Previous slide

Next slide

Back to first slide

View graphic version