:::: MENU ::::

Date Correlation Optimization Enabled (date_correlation_optimization_option) in SQL Server

  • Nov 05 / 2008
  • 0
Constraints and Keys, DBA Interview questions, dbDigger

Date Correlation Optimization Enabled (date_correlation_optimization_option) in SQL Server

Date Correlation Optimization option controls the date correlation optimization. The date correlation optimization improves performance of queries that perform an equijoin between two tables that specify a date restriction in the query’s WHERE clause predicate, and whose datetime columns are linked by a foreign key constraint.
Setting the Date Correlation Optimization Enabled to TRUE directs SQL Server to maintain correlation statistics between any two tables in the database that are linked by a FOREIGN KEY constraint and have datetime columns.
Setting this option to FALSE disables date correlation.
Consult us to explore the Databases. Contact us