24
Creating Indexes
Indexes
can be useful in range queries too:
B+
trees help in:
Why
not create indexes on everything?
CREATE INDEX ageIndex ON Person (age)
SELECT *
FROM Person
WHERE age > 25 AND age < 28
FROM Person
WHERE age > 25 AND age < 28