Question

The maximum number of indexes on MyISAM table is __________

(a) 0

(b) 1

(c) 2

(d) more than 1

This question was addressed to me in class test.

This is a very interesting question from Using Indexing topic in division Query Optimization of MySQL

Answer 1

Correct choice is (d) more than 1

To elaborate: In MySQL, for a MyISAM table, there can be more than one indexes. The data rows of the MyISAM table are stored in a data file and the index values are stored in a separate index file.