Partial Range Scan

What’s Partial Range Scan

The Partial Range Scan doesn’t mean to scan all the data that meet the conditions (predicates) in the SQL Where clause; instead it means that the SQL engine doesn’t need to scan all the data before returning the first set of data to the users. This is similar to what the optimizer mode “FIRST_ROWS” indicates.
Partial Range Scan is very helpful for the OLTP operations, but this doesn’t mean the partial range scan cannot be used in the batch process operations.
Partial Range Scan can reduce the data volume that need to scan and to what extent the data volume that the Partial Range Scan need to scan is not impacted by the data volume that meets the conditions (predicates) in the WHERE clause. This is the charming characteristic of the Partial Range Scan.