UseDefaultOrderBy
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 Excel Add-In for Quickbase 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.