I want to optimize my database. So I need to learn about INDEXES or KEYS in MySQL. Can you explain that how many types of INDEXES or KEYS are in MySQL?
Answer No: 136
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.