Skip to main content

Search

Welcome to Tibero GTS!

Issue of Index Range Scan Scanning in DESC Direction

Document Type | Troubleshooting 

Category | Patch/Upgrade

Applicable Product Versions | 6FS07, 7FS02

Document Number | TPATS016

 

Issue

In queries using COUNT STOP, an issue occurred where the Index Range Scan was performed in the DESC (Descending) direction instead of ASC (Ascending).
Note
ASC scans index key values from smaller to larger values, while DESC scans in the opposite direction, from larger to smaller values.

 

Cause

This phenomenon occurs because in execution plans that include a COUNT STOP node, the path with a higher cost is preferentially selected, resulting in the Index Range Scan being performed in the DESC direction.

 

Solutions

Apply patch 271432 to fix the issue where the path with a higher cost is executed first in execution plans that include a COUNT STOP node.
Caution
Apply the patch through technical support provided by TmaxTIBERO.
 
 
 

Related to