The purpose of database indexes is to improve query performance. This is done by reducing the amount of data searched through during query execution to find the query result set. Indexes are ordered data structures containing data from table columns with pointers to the full data row.
