Index scan - key positioning, parallel icon

Index Scan - Key Positioning, Parallel

The Index Scan - Key Positioning, Parallel icon indicates that multiple tasks were used to perform the key positioning in parallel. The range of key values was determined by the selection criteria whose predicates matched the key columns of the index. The number of selected key entries were further reduced by the use of index key selection or derived selection after key positioning was completed. Only selected key entries were used to select rows from the corresponding table data.

See Tips for parallel index key positioning for more details.