How many maximum possible indexes we can create in mysql table?
database, mysql
Solution
The maximum number of indexes per table and the maximum index length is defined per storage engine. See Chapter 15, Alternative 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.
From the MySQL Documentation.
Problem
Is there any Maximum limit in MySQL table, that we can only create a fix amount of indexes in a table? What is the Maximum possible number of index be created in a table?