The OPTIMIZE TABLE command should be used...

The correct answer is A. To increase performance by defragmenting the table. B. To improve performance by sorting indexes. C. To improve performance by updating index statistics. The OPTIMIZE TABLE statement cleans up a MyISAM table by defragmenting it. This involves reclaiming unused space resulting from deletes and updates, and coalescing records that have become split and stored non-contiguously. OPTIMIZE TABLE also sorts the index pages if they are…

MySQL Database Maintenance

Question

Options

ATo increase performance by defragmenting the table.
BTo improve performance by sorting indexes.
CTo improve performance by updating index statistics.
DTo correct problems with a MyISAM table that have become corrupted.
ETo check a tables structure to see if it may have been damaged and needs repair.

How the community answered

(47 responses)

A
83% (39)
D
13% (6)
E
4% (2)

Explanation

The OPTIMIZE TABLE statement cleans up a MyISAM table by defragmenting it. This involves reclaiming unused space resulting from deletes and updates, and coalescing records that have become split and stored non-contiguously. OPTIMIZE TABLE also sorts the index pages if they are out of order and updates the index statistics.

Topics

#OPTIMIZE TABLE#defragmentation#index sorting#table maintenance

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice