Describe the types of table maintenance statements used in S

Describe the types of table maintenance statements used in SQL. Who should use these statements and why?

Solution

there are 4 types of table maintainace statements in SQL. These are:

1. Analayze table

2. Check table

3. Repair table

4. optimize table

ANALYZE TABLE analyzes and stores the key distribution for a table.

Analyze table table-name;

MySQL allows you to check the integrity of database tables by using the CHECK TABLE statement.

Check table table-name;

The REPAIR TABLE statement allows you to repair some errors occurred in database tables.

Repair table table-name;

MySQL provides you with a statement that allows you to OPTIMIZE the table to avoid this defragmenting problem.

Optimize Table table-name;