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.


Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.