Tag - descending indexes

MySQL 8.0: Descending Indexes Can Speed Up Your Queries

MySQL 8.0 innodb_dedicated_server

In this blog, we’ll discuss descending indexes in MySQL 8.0.
Summary
The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release (new optimizer preview), when you create an index you can specify the order […]

Read more