0: jdbc:ignite:thin://127.0.0.1/> select * from sys.indexes; +----------------+-------------------+-------------+-------------------+-------------+------------+--------------+------------+----------------------------------------+-------+-----------+-------------+ | CACHE_GROUP_ID | CACHE_GROUP_NAME | CACHE_ID | CACHE_NAME | SCHEMA_NAME | TABLE_NAME | INDEX_NAME | INDEX_TYPE | COLUMNS | IS_PK | IS_UNIQUE | INLINE_SIZE | +----------------+-------------------+-------------+-------------------+-------------+------------+--------------+------------+----------------------------------------+-------+-----------+-------------+ | -2066691984 | SQL_PUBLIC_CITY | -2066691984 | SQL_PUBLIC_CITY | PUBLIC | CITY | _key_PK_hash | HASH | "ID" ASC | false | true | null | | -2066691984 | SQL_PUBLIC_CITY | -2066691984 | SQL_PUBLIC_CITY | PUBLIC | CITY | __SCAN_ | SCAN | | false | false | null | | -2066691984 | SQL_PUBLIC_CITY | -2066691984 | SQL_PUBLIC_CITY | PUBLIC | CITY | _key_PK | BTREE | "ID" ASC | true | true | 9 | | -1447683814 | SQL_PUBLIC_PERSON | -1447683814 | SQL_PUBLIC_PERSON | PUBLIC | PERSON | _key_PK_hash | HASH | "ID" ASC, "CITY_ID" ASC, "CITY_ID" ASC | false | true | null | | -1447683814 | SQL_PUBLIC_PERSON | -1447683814 | SQL_PUBLIC_PERSON | PUBLIC | PERSON | __SCAN_ | SCAN | | false | false | null | | -1447683814 | SQL_PUBLIC_PERSON | -1447683814 | SQL_PUBLIC_PERSON | PUBLIC | PERSON | _key_PK | BTREE | "ID" ASC, "CITY_ID" ASC | true | true | 18 | | -1447683814 | SQL_PUBLIC_PERSON | -1447683814 | SQL_PUBLIC_PERSON | PUBLIC | PERSON | AFFINITY_KEY | BTREE | "CITY_ID" ASC, "ID" ASC | false | false | 18 | | -1447683814 | SQL_PUBLIC_PERSON | -1447683814 | SQL_PUBLIC_PERSON | PUBLIC | PERSON | PERSON_IDX | BTREE | "CITY_ID" ASC, "ID" ASC | false | false | 18 | +----------------+-------------------+-------------+-------------------+-------------+------------+--------------+------------+----------------------------------------+-------+-----------+-------------+ 0: jdbc:ignite:thin://127.0.0.1/> !indexes +-----------+-------------+------------+------------+-----------------+--------------+------+------------------+-------------+-------------+-------------+-------+------------------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | NON_UNIQUE | INDEX_QUALIFIER | INDEX_NAME | TYPE | ORDINAL_POSITION | COLUMN_NAME | ASC_OR_DESC | CARDINALITY | PAGES | FILTER_CONDITION | +-----------+-------------+------------+------------+-----------------+--------------+------+------------------+-------------+-------------+-------------+-------+------------------+ | IGNITE | PUBLIC | CITY | false | | _key_PK | 3 | 1 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | CITY | false | | _key_PK_hash | 3 | 1 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | CITY | true | | __SCAN_ | 3 | null | | | 0 | 0 | | | IGNITE | PUBLIC | PERSON | false | | _key_PK | 3 | 1 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | false | | _key_PK | 3 | 2 | CITY_ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | false | | _key_PK_hash | 3 | 1 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | false | | _key_PK_hash | 3 | 2 | CITY_ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | false | | _key_PK_hash | 3 | 3 | CITY_ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | true | | AFFINITY_KEY | 3 | 1 | CITY_ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | true | | AFFINITY_KEY | 3 | 2 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | true | | PERSON_IDX | 3 | 1 | CITY_ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | true | | PERSON_IDX | 3 | 2 | ID | A | 0 | 0 | | | IGNITE | PUBLIC | PERSON | true | | __SCAN_ | 3 | null | | | 0 | 0 | | +-----------+-------------+------------+------------+-----------------+--------------+------+------------------+-------------+-------------+-------------+-------+------------------+