-An index is a data structure of MySQL table that is used to speed up the queries.
-It is used by the database search engine to find out the records faster. One or more fields of a table can be used as an index key. Index key can be assigned at the time of table declaration or can be assigned after creating the table.
Read More →