how many index i can create for one table in mysql.
Depends on your server, but usually 32 or 64 per table. Note that there are also limits on the max index length.
There is No fixed number for indexes and it totally depend on Your queries.
But Make sure that the more indexes you have, the slower inserts and updates will be..(In case of PhpMyAdmin)
Adding an index is a slow operation with big tables.
Adminer allows manipulation with all indexes together.
The maximum number of indexes per table and the maximum index length is defined per storage engine. See Chapter 14, Storage Engines. All storage engines support at least 16 indexes per table and a total index length of at least 256 bytes. Most storage engines have higher limits.
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.