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

posted by  mneon (8)  15 months ago (blogs.msdn.com)

So in Part II of this article I had created a View so that I could then create an index on this view to see if that was going to give me the expected results. I did create the view, but not the index. So you probably already know. These columns are non-deterministic...(read more)