Databases Reference
In-Depth Information
With this change in the query, the execution plan uses a
SORT
operation. This can be
observed in the following screenshot:
If we have the index in place, the execution plan changes as follows: