Skip to main content

system.indexes

Introduced: v1.1.50

Contains information about the created aggregating indexes.

CREATE TABLE t1(a int,b int);

CREATE AGGREGATING INDEX idx1 AS SELECT SUM(a), b FROM default.t1 WHERE b > 3 GROUP BY b;

SELECT * FROM system.indexes;

+----------+-------------+------------------------------------------------------------+----------------------------+
| name | type | definition | created_on |
+----------+-------------+------------------------------------------------------------+----------------------------+
| test_idx | AGGREGATING | SELECT b, SUM(a) FROM default.t1 WHERE (b > 3) GROUP BY b | 2023-05-17 11:53:54.474377 |
+----------+-------------+------------------------------------------------------------+----------------------------+

See also: SHOW INDEXES