Question

To maintain performance of tables having variable length rows, which statement is used?

(a) MAINTAIN TABLE

(b) BALANCE TABLE

(c) ADJUST TABLE

(d) OPTIMIZE TABLE

I got this question by my school principal while I was bunking the class.

My enquiry is from Choosing Data Types for Efficient Queries in chapter Query Optimization of MySQL

Answer 1

The correct option is (d) OPTIMIZE TABLE

Best explanation: In the variable length rows, there is more fragmentation of the table on which many deletes or updates are performed. OPTIMIZE TABLE is run periodically to maintain performance.