Return
-
Title
Performance is slow when sorting data grid columns -
Description
When sorting a data grid column it takes a long time to do the sort.
-
Cause
Setting NULLS (First or Last) to be the opposite of what the default setting is for the ascending or descending choice.
-
Resolution
Set NULLS LAST when using ascending order and NULLS FIRST when using descending order.
-
Defect ID
ST63065 -
Additional Information
According to Oracle documentation, NULLS LAST is the default for ascending order, and NULLS FIRST is the default for descending order.