Question

Name some table maintenance commands

Answer 1

Answer:

Summary: in this tutorial, we will introduce you to some very useful statements that allow you to maintain database tables in MySQL. ... Those statements enable you to analyze, optimize, check, and repair database tables. ... MySQL query optimizer is an important component of the MySQL ...

Answer 2

Some Table Maintenance command  

Explanation:

Table Maintenance refers to optimize the table operations to recover the disk space and improve the input efficiency. These command ensures that the operation carried out is in optimize table documentation.  

Table Maintenance commands :

• Analyze Table Statement (

Command :    ANALYZE TABLE table_Name;

* table name : payment

• Optimize Table Statement (insert , update and delete)

Command :    OPTIMIZE TABLE table_Name;

• Check Table Statement ( checks the entries)

Command :    CHECK TABLE table_Name;

• Repair Table Statement ( repairs some errors in the database)

Command :    REPAIR TABLE table_Name;