Question: what are index range scan?
Answer: Index range scan Index range scan is a method for accessing a range values of a particular column. AT LEAST the leading column of the index must be supplied to access data via the index. It can be used for range operations (e.g. > < >= <= between ) or where the data to be returned is not unique.