Hi,
how many index i can create for one table in mysql.
chandbasha
0
Newbie Poster
Recommended Answers
Jump to PostDepends on your server, but usually 32 or 64 per table. Note that there are also limits on the max index length.
All 3 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Depends on your server, but usually 32 or 64 per table. Note that there are also limits on the max index length.
ankit.jivrani
0
Newbie Poster
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.
:)
smantscheff
265
Veteran Poster
http://lmgtfy.com?q=mysql+number+of+indexes
http://dev.mysql.com/doc/refman/5.5/en/column-indexes.html
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.