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).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 newsystem.data_skipping_indices table using a simple SELECT statement to retrieve information about all data skipping indices defined on tables in the ClickHouse server.