MySQL allows four general types of indexes (keys). These indexes can be created either on single column or multi-columns however both single column index and multi columns index have some different behaviors.
- Primary Key Indexes
- Unique Key Indexes
- Normal Indexes also known as "Non-Unique Indexes", "Ordinary Indexes", or "Indexes without constraints"
- Full-Text Indexes
Posted in: MySQL