列的统计信息（转）

最新推荐文章于 2026-06-21 15:14:42 发布

原创最新推荐文章于 2026-06-21 15:14:42 发布 · 10 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#数据库 #mysql

收录于

select /*+LEADING(((c b) a) t) use_nl(b) use_nl(a) use_nl(t) */
 b.table_name,
 t.partition_id,
 a.column_name,
 num_distinct,
 t.num_null,
 t.min_value,
 t.max_value
  from __all_virtual_column_statistic t,
       __all_virtual_column         a,
       __all_virtual_table          b,
       __all_virtual_database       c
 where t.tenant_id = a.tenant_id
   and t.table_id = a.table_id
   and t.column_id = a.column_id
   and a.tenant_id = b.tenant_id
   and a.table_id = b.table_id
   and b.tenant_id = c.tenant_id
   and b.database_id = c.database_id
   and c.tenant_id = 1001
   and c.database_name = 'SYS'
   and b.table_name = 'TESTTAB1';
   
   
+------------+--------------+----------------+--------------+----------+------------------------------+------------------------------+
| table_name | partition_id | column_name    | num_distinct | num_null | min_value                    | max_value                    |
+------------+--------------+----------------+--------------+----------+------------------------------+------------------------------+
| TESTTAB1   |            0 | __pk_increment |        99015 |        0 | 0A053FFF01                   | 0A053FFFA08D06               |
| TESTTAB1   |            1 | __pk_increme