> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing a list of data skipping index types supported by the server along with their embedded documentation.

# system.data_skipping_index_types

<h2 id="description">
  Description
</h2>

Contains the list of data skipping index types supported by the server, along with embedded documentation for each type. A data skipping index type is specified in the `TYPE` of an `INDEX` declaration in a `CREATE TABLE` query and lets ClickHouse skip granules that cannot match a query's condition.

Note that this table lists the available index *types*, whereas [`system.data_skipping_indices`](/reference/system-tables/data_skipping_indices) lists the index instances defined on existing tables.

<h2 id="columns">
  Columns
</h2>

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

<h2 id="example">
  Example
</h2>

```sql title="Query" theme={null}
SELECT name, syntax
FROM system.data_skipping_index_types
WHERE name IN ('minmax', 'set')
ORDER BY name
```

```text title="Response" theme={null}
┌─name───┬─syntax───────────────────────────────────────┐
│ minmax │ INDEX name expr TYPE minmax GRANULARITY n     │
│ set    │ INDEX name expr TYPE set(max_rows) GRANULARITY n │
└────────┴──────────────────────────────────────────────┘
```

<h2 id="see-also">
  See also
</h2>

* [Data skipping indices](/concepts/features/performance/skip-indexes/skipping-indexes) — Information about data skipping indexes.
* [`system.data_skipping_indices`](/reference/system-tables/data_skipping_indices) — The index instances defined on existing tables.