Indicates whether a default ORDER BY clause should be applied when none is specified in the query. This helps ensure consistent sorting of results and prevents duplicate records from appearing in the output.

Data Type

bool

Default Value

true

Remarks

By default, the CData Excel Add-In for Jira applies an ORDER BY clause when none is specified in the query. This ensures that records are returned in a predictable order and helps prevent duplicate records from appearing. However, this default behavior can significantly impact performance, especially for very large tables, as it requires sorting all the results before returning them.

The use of ORDER BY can slow down queries, especially when dealing with large datasets, as sorting large numbers of records is resource-intensive. The ORDER BY clause is applied to avoid the potential issue of duplicate records, particularly when querying large datasets where primary keys might not be unique in certain cases.

If your use case can tolerate the possibility of duplicate primary keys and you want to improve query performance, you can disable this property by setting it to 'false'. This preventd the system from automatically applying the ORDER BY clause, which may lead to faster results, particularly when working with large datasets.