Indexing in databases is like creating a table of contents for quick access to data. It speeds up data retrieval by allowing the database engine to find rows faster without scanning the entire table. Proper indexing can significantly improve query performance, especially for large datasets.