Attribute

EnablePagingWithOrderByID (EPWO)

Purpose

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.

Default

1 (Enabled)

GUI Tab

Advanced tab

This connection option can affect performance. See Performance considerations for details.