SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part II

I have now started the process of evaluating the other possible ways of executing the query. These include using a derived table, Common Table Expression and an Indexed View. My intent is to not use any functions that could twist my results. Below is the script that I used and the result.   SELECT ID,MonthPart,YearPart FROM…

3