Specifies whether the driver can inject the Order By clause in the Select query for each ODBC call. When enabled, this option provides a stable paging mechanism for retrieving result sets larger than site configured maximum.
Valid Values
1 | 0
Behavior
If set to 1 (Enabled), the driver can inject the Order By clause into the Select query.
If set to 0 (Disabled), the driver cannot inject the Order By clause into the Select query.
Notes
If your application does not retrieve large result sets, consider disabling this feature, because adding the Order By clause can have a negative performance impact on queries.
If your application does not retrieve large result sets, consider disabling this feature, because adding the Order By clause can have a negative performance impact on queries.