The maximum number of indexes on MyISAM table is

Mr. Dubey

🎓 Coach ⭐ 104.58K Points

📊 Information Retrival Techniques

Q. The maximum number of indexes on MyISAM table is

(A) 0
(B) 1
(C) 2
(D) more than 1

💬 Discuss

✅ Correct Answer: (D) more than 1

Explanation: 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.

Explanation by: Mr. Dubey

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.

💬 Discussion

📊 Question Analytics

👁️

914

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

80%

Success Rate

Mr. Dubey

Explanation by: Mr. Dubey

💬 Discussion

Related MCQs

📊 Question Analytics