-- 列的基数
select column_name,count(*) from table group by column_name order by 2 desc
-- 列的选择性
select
a.TABLE_NAME as "表名称",
a.COLUMN_NAME as "表中列名称",
a.CARDINALITY as "列的基数",
b.TABLE_ROWS as "表中总行数",
ROUND(a.CARDINALITY / b.TABLE_ROWS * 100 ,2 ) as "选择性"
from information_schema.STATISTICS a , information_schema.`TABLES` b
where a.TABLE_NAME = b.TABLE_NAME
and a.TABLE_SCHEMA = "test"
and a.TABLE_NAME = "test" ;
-- 列的选择性过低,减少数据总数量,定时批量删除无效数据
SQL 优化核心思想SQL 优化必懂的概念概念英文含义影响示例计算临界基数Cardinality某个列唯一键(Distinct Keys)的数量基数的高低影响列的数据分布性别字段基数为2select column_name,count(*) from table group by column_name order by 2 desc5%,当某列的查...