Indexes & Performance

Why indexes matter

An index is a sorted lookup structure — it turns a full scan into a jump.

CREATE INDEX idx_courses_category ON courses (category);
-- now WHERE category = 'design' is fast

• Index columns you filter/join on
• Don't over-index — writes get slower
• Use EXPLAIN to see the plan