Specifies whether the provider applies a default ORDER BY clause when none is included in the query.

Data Type

bool

Default Value

true

Remarks

This property controls whether the driver automatically orders results when an ORDER BY clause is not specified in the query.

Set this property based on your performance and data consistency needs.

When this property is set to true, the driver applies a default ORDER BY clause to ensure that duplicate records are not returned. This may impact performance on very large tables.

When this property is set to false, no default ORDER BY clause is applied, which improves performance, but may allow duplicate primary keys in the results.

This property is useful when tuning performance for large data sets or when the order of returned records is not critical.