Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which of these best reduces the size of a large InnoDB table's file after deleting many rows?

  1. A DELETE with a WHERE clause
  2. B OPTIMIZE TABLE
  3. C FLUSH TABLES
  4. D ANALYZE TABLE
Answer

OPTIMIZE TABLE

DELETE marks pages reusable but does not shrink the tablespace file. OPTIMIZE TABLE rebuilds the table and reclaims the space.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as