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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property DateCorrelationOptimization As Boolean 
    Get 
    Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.DateCorrelationOptimization

instance.DateCorrelationOptimization = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public bool DateCorrelationOptimization { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
virtual property bool DateCorrelationOptimization {
    bool get () sealed;
    void set (bool value) sealed;
}
[<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
final function get DateCorrelationOptimization () : boolean 
final function set DateCorrelationOptimization (value : boolean)

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.

Implements

IDatabaseOptions.DateCorrelationOptimization

Remarks

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

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Optimizing Queries That Access Correlated datetime Columns