23
Creating Indexes
Indexes can be created on more than one
attribute:
CREATE INDEX doubleindex ON
Person (age, city)
Person (age, city)
SELECT *
FROM Person
WHERE age = 55 AND city = “Seattle”
FROM Person
WHERE age = 55 AND city = “Seattle”
SELECT *
FROM Person
WHERE city = “Seattle”
FROM Person
WHERE city = “Seattle”
Helps in:
But not in:
Example: