system.data_skipping_index_types

​

Description

​

Columns

• name (String) — The name of the data skipping index type, as specified in the TYPE of an INDEX declaration.
• description (String) — A high-level description of what the data skipping index type does.
• syntax (String) — How the index is declared in an INDEX clause of a CREATE TABLE query.
• examples (String) — Usage examples.
• introduced_in (String) — The ClickHouse version in which the index type was first introduced, in the form major.minor.
• related (Array(String)) — The names of related data skipping index types.

​

Example

SELECT name, syntax
FROM system.data_skipping_index_types
WHERE name IN ('minmax', 'set')
ORDER BY name

┌─name───┬─syntax───────────────────────────────────────┐
│ minmax │ INDEX name expr TYPE minmax GRANULARITY n     │
│ set    │ INDEX name expr TYPE set(max_rows) GRANULARITY n │
└────────┴──────────────────────────────────────────────┘

​

See also

• Data skipping indices — Information about data skipping indexes.
• system.data_skipping_indices — The index instances defined on existing tables.