SQL CREATE INDEX  is used to create indexes in tables.

It let the database application to find data fast  .

Example

mysql> CREATE INDEX user_index ON users (uid);
Query OK, 5 rows affected (0.12 sec)
Records: 5  Duplicates: 0  Warnings: 0