"INDEX RANGE SCAN DESCENDING" Not Used after Adding Column to Index
(Doc ID 2752380.1)
Last updated on MARCH 31, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On 184.108.40.206.0 of Oracle an expected "INDEX RANGE SCAN DESCENDING" is not used.
A recent upgrade to 18.4 of Oracle and a new column(s) is added to an index.
After adding one column to index (see testcase.sql and uncomment it when create index) we see
INDEX RANGE SCAN IDX_DH_LCD
INDEX RANGE SCAN DESCENDING IDX_DH_LCD
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document