This course has been updated! We now recommend you take the Complete Intro to SQL & PostgreSQL course.

Check out a free preview of the full SQL Fundamentals course:
The "Indices" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

Indices are a speed-for-memory tradeoff, where the database does some extra bookkeeping to keep queries fast. Mike looks at how to identify an opportunity for adding an index, how to create one, and how to measure its effectiveness.

Get Unlimited Access Now