v.24.3Improvement

SHOW INDEX command no longer sorts by primary key columns

Official CH changelog text
SHOW INDEX | INDEXES | INDICES | KEYS no longer sorts by the primary key columns (which was unintuitive). #60514 (Robert Schulze).
SHOW INDEX | INDEXES | INDICES | KEYS commands no longer sort the output by the primary key columns, improving the intuitiveness of the results.

Why it matters

Previously, the output of index-related SHOW commands was sorted by primary key columns, which could be confusing and unintuitive for users analyzing index information. This change removes that enforced sorting, making the output order more natural and aligned with user expectations.

How to use it

Simply execute any of the following commands as before to list indexes without automatic sorting by primary key columns:

SHOW INDEX
SHOW INDEXES
SHOW INDICES
SHOW KEYS

Related resources

PreviousNext