TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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)

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Standalone | SfcPropertyFlags::SqlAzureDatabase | SfcPropertyFlags::Deploy)]
property bool DateCorrelationOptimization {
	virtual bool get() sealed;
	virtual void set(bool value) sealed;
}

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:
© 2016 Microsoft