SqlServerKudos - The optimiser should understand that year(datecolumn) is correlated to the datecolumn

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

The optimiser should understand that year(datecolumn) is correlated to the datecolumn

published 416 days, 23 hours, 11 minutes ago posted by

sa 426 days, 1 hour, 48 minutes ago

The optimiser should understand that year(datecolumn) is correlated to the datecolumn

If you have a query such as select year ( OrderDate ) yr , count ( 1 ) from AdventureWorks2008 . Sales . SalesOrderHeader group by year ( OrderDate ) and you have an index on OrderDate you will find that even though the query optimiser could do a stream...(read more)

category: News | clicked: 0 | | source: sqlblogcasts.com | show counter code

tags: Connect, Performance, Suggestions

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos