13.4.3 Optimisation de tables

To coalesce fragmented records and eliminate wasted space resulting from deleting or updating records, run isamchk in recovery mode:

shell> isamchk -r nom_table

You can optimize a table in the same way using the SQL OPTIMIZE TABLE statement. OPTIMIZE TABLE is easier, but isamchk is faster.

isamchk also has a number of other options you can use to improve the performance of a table:

-S, --sort-index

-R index_num, --sort-records=index_num

-a, --analyze

For a full description of the option see 13.1.1 Syntaxe isamchk.