Advantages of Indexes Indexes reduce the time it takes to retrieve rows from a database. The faster the retrieval, the better.