【MySql】【索引优化】快速定位不合理的索引
直接执行语句
SELECT
t.TABLE_SCHEMA,t.TABLE_NAME,INDEX_NAME, CARDINALITY,
TABLE_ROWS, CARDINALITY/TABLE_ROWS AS SELECTIVITY
FROM
information_schema.TABLES t,
(
SELECT table_schema,table_name,index_name,card...
原创
2019-06-26 17:31:59 ·
223 阅读 ·
0 评论