Indicates if a default order by should be applied if none is specified in the query.

Data Type

bool

Default Value

true

Remarks

By default, the CData ODBC Driver for Bullhorn CRM applies an order by when none is specified. This ensures that duplicate records do not get output when returning data. However, this will have a significant impact on performance for very large tables. If your use case can handle the possibility of duplicate primary keys, it is recommended to turn this off if you would like to have better performance.