MySQL Indexing

Indexing is used to speed up the whole operations occur in MySQL tables by providing a way for a database management system to go directly on a row rather than having to search all the rows until it finds the correct one you want. MySQL creates indexes for the primary keys, foreign keys, unique keys and fulltext.

To Create An Index

Syntax

CREATE INDEX index_name ON table_name ( column1, column2
 ,...);

Example of Index

CREATE INDEX Student_id ON student_info (Student_name)

Click Here To Read MySQL Indexing Tutorial