1、先來看看多次刪除插入操作后的表索引情況

mysql> SHOW INDEX FROM `tbl_name`;+----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |+----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| tbl_name | 0 | PRIMARY | 1 | StepID | A | 1 | NULL | NULL | | BTREE | || tbl_name | 1 | FlowID | 1 | FlowID | A | 1 | NULL | NULL | | BTREE | || tbl_name | 1 | WagerCount | 1 | WagerCount | A |

總結

以上是生活随笔為你收集整理的mysql中OPTIMIZE TABLE的作用的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。