Question

Purpose of an index

Answer 1

A purpose of an index is to increase a performance of data search. The index has a structure which is optimized for search, for instance, a structure of a binary search tree, so the search by the index is quicker than the search by sequential iterating over the rows.