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)>]
abstract DateCorrelationOptimization : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy)>]
override DateCorrelationOptimization : bool with 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: