SqlUserDefinedAggregateAttribute.IsInvariantToOrder Property


Indicates whether the aggregate is invariant to order.

 property bool IsInvariantToOrder { bool get(); void set(bool value); };
public bool IsInvariantToOrder { get; set; }
member this.IsInvariantToOrder : bool with get, set
Public Property IsInvariantToOrder As Boolean

Property Value


true if the aggregate is invariant to order; otherwise false.


Reserved for future use. This property is not currently used by the query processor: order is currently not guaranteed.

Incorrectly setting this property can result in incorrect query results. This property is not an optimizer hint; it affects the plan selected and the results returned by the query.

The default value for this property is false.

Applies to