Enable visualization of the actual content stored in ClickHouse secondary indexes (Skip Indexes) to better understand and debug index usage. This will help debug index effectiveness, optimize performance, and troubleshoot issues with queries not using expected indexes.
## Feature Description Enable visualization of the actual content stored in ClickHouse secondary indexes (Skip Indexes) to better understand and debug index usage. ## Use Cases 1. **Debug index effectiveness**: View the actual values stored in indexes to verify that indexes are correctly built 2. **Performance optimization**: Analyze index distribution to determine if indexes are effective 3. **Troubleshooting**: When queries don't use expected indexes, view index content to diagnose issues 4. **Learning and understanding**: Help users better understand how ClickHouse indexes work ## Current State Currently, we can view index information through: - `system.data_skipping_indices` table: View index definitions and metadata - `system.query_log.skip_indices` column (#87862): View which indexes were used - `EXPLAIN` statement: View index usage in query plans - `mergeTreeIndex` table function: View primary key index and marks files - `mergeTreeTextIndex` table function: View text index