system.data_skipping_indices
Contains information about existing data skipping indices in all the tables.
Columns:
database
(String) — Database name.table
(String) — Table name.name
(String) — Index name.type
(String) — Index type.expr
(String) — Expression for the index calculation.granularity
(UInt64) — The number of granules in the block.
Example
SELECT * FROM system.data_skipping_indices LIMIT 2 FORMAT Vertical;
Row 1:
──────
database: default
table: user_actions
name: clicks_idx
type: minmax
expr: clicks
granularity: 1
Row 2:
──────
database: default
table: users
name: contacts_null_idx
type: minmax
expr: assumeNotNull(contacts_null)
granularity: 1
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .