Q. To perform analysis of key values by the server, the statement used is . . . . . . . .
-
(A)
ANALYZE KEYS
-
(B)
ANALYZE TABLE
-
(C)
PERFORM ANALYSIS
-
(D)
PERFORM TABLE ANALYSIS
✅ Correct Answer: (B)
ANALYZE TABLE
Explanation: This question is asking about how you tell MySQL to gather information about the indexes (key values) within your tables.