v.21.8New Feature

Introduce system.data_skipping_indices table for index information

Introduce system.data_skipping_indices table containing information about existing data skipping indices. Close #7659. #25693 (Dmitry Novik).
Introduces the system.data_skipping_indices table that provides detailed information about existing data skipping indices in ClickHouse.

Why it matters

This feature addresses the need for users to inspect and monitor data skipping indices directly from the system tables. It helps users understand which data skipping indices are available, improving query optimization and performance troubleshooting.

How to use it

Users can query the new system.data_skipping_indices table using a simple SELECT statement to retrieve information about all data skipping indices defined on tables in the ClickHouse server.