The Basics of Database Indexing

A database index works like a book's index, letting the database quickly locate specific rows without scanning every single record. Without proper indexing, queries on large tables can become painfully slow as data grows. Adding a thoughtful index to frequently searched columns is one of the highest-impact database optimizations available.