Support for MySQL Descending Indexes

[TomorrowToday]

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

1. MySQL 8.4

2. TablePlus Version 6.1.6 (570)

3. This is a feature request.

MySQL 8.x supports DESC/ASC in index definitions. For example:

CREATE TABLE t (
  c1 INT, c2 INT,
  INDEX idx1 (c1 ASC, c2 ASC),
  INDEX idx2 (c1 ASC, c2 DESC),
  INDEX idx3 (c1 DESC, c2 ASC),
  INDEX idx4 (c1 DESC, c2 DESC)
);

This feature matters because it makes ORDER BY operations faster by not requiring a filesort. It would be helpful for TablePlus to have options for this when creating/editing an index.

More information is available in the MySQL Docs