Indexing in tables

Indexing makes columns faster to queries by creating pointers to where the data is stored in the database.

Reference

1) how to apply indexes 2) how indexing works 3) choosing index on cardinality