Specifying Index Sort Order

By default, SQL stores an index in ascending order. To make a descending sort on a column or group of columns more efficient, use the DESCENDING keyword to define the index.

Creating the budgetx DESCENDING Index

Enter and execute the following code to create an index called budgetx that is in descending order:

CREATE DESCENDING INDEX budgetx ON Department (budget)

Advance To:

Modifying Indexes