SELECT
s.TABLE_NAME,
s.COLUMN_NAME,
s.INDEX_TYPE,
s.INDEX_NAME,
t.TABLE_ROWS,
s.`CARDINALITY`,
IFNULL(round( s.`CARDINALITY` / t.TABLE_ROWS ,2), 1) as CARDINALITY_SUM
FROM
STATISTICS AS s
JOIN `TABLES` AS t ON s.TABLE_SCHEMA = t.TABLE_SCHEMA
AND s.TABLE_NAME = t.TABLE_NAME
WHERE
s.TABLE_SCHEMA = "testtest"
AND s.`INDEX_NAME` != "PRIMARY"
order by
CARDINALITY_SUM ASC
这条sql语句的CARDINALITY_SUM 越接近1索引条件越好