O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Descending index

Prior to MySQL 8, an index definition could contain the order (ascending or descending), but it was only parsed and not implemented. The index values were always stored in ascending order. MySQL 8.0 introduced support for descending indexes. Thus, the specified order in the index definition is not ignored. A descending index actually stores key values in descending order. Remember that scanning an ascending index in reverse is not efficient for a descending query.

Consider a case where, in a multi-column index, you can specify certain columns to be descending. This can help for queries wherein we have both ascending and descending ORDER BY clauses.

Suppose you want to sort the employees table with first_name ascending and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required