What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

by

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

Question:

What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

Options:

ANALYZE TABLE INVENTORY;

mysqlcheck INVENTORY

mysqldump INVENTORY

OPTIMIZE TABLE INVENTORY;

Correct Answer

The Correct Answer for this Question is

OPTIMIZE TABLE INVENTORY;

Leave a Comment