The reverse scan in DB2 also called backward index scan. Reverse Scan The ordering of an index has implications for how DB2 will elect to use that index when satisfying a query. When you create an index, you either choose the default ascending ordering, or explicitly choose ascending or descending ordering to suit your needs. … Continue reading All About DB2 Backward Index Scan