Database.DateCorrelationOptimization Property

 

Gets or sets a value that specifies whether the date correlation optimization is active.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy)]
public bool DateCorrelationOptimization { get; set; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the date correlation optimization is active. If True, date correlation optimization is active. If False (default), date correlation optimization is not active.

For more information about date correlation optimization, see Setting Database Options.

Database Class
Microsoft.SqlServer.Management.Smo Namespace
Optimizing Queries That Access Correlated DateTime Columns

Return to top
Show: