1.Primary Key
2.Unique index
3.Normal index
4.Fulltext index
5.Clustered index
Every InnoDB table has a special index called the clustered index where the data for the rows is stored.
When you define a PRIMARY KEY on your table, InnoDB uses it as the clustered index.
6.Secondary index
All indexes other than the clustered index are known as secondary indexes.
