Consider the ANALYZE TABLE command.
In which two situations should this command be used?
when you want to check a tables structure to see if it may have been damaged and needs repair
when you need to find out why a query is taking a long time to execute
when you want to update index distribution statistics
after large amounts of table data have changed
Submit