An index is created from one or more columns and is stored outside the table.
Because it only contains data relevant to the search or sort operation, it can be traversed more quickly than the table itself, and is useful for implementing custom search comparison or sort orders since the result of the functions used can be cached in the index.
Indexes are also useful for separating read and write loadings, as indexes can be stored on a different machine to the live database itself.