Experience with Indexed View

I had a bad experience working with Indexed view because, well, I didn't have much experience working with Indexed View.  I hit 5 major issues before I finally gave up.
  • Indexed view does not allow GETDATE() because it's a non-deterministic data type.  I could not limit my result set, or put a flag column based on the age of the record.
  • Indexed view does not allow self join
  • Indexed view does not allow OUTER JOIN
  • Indexed view does not do COUNT(*)
  • Indexed view does not allow subqueries
  • Indexed view does not do xQuery (have to build that in function first)

Moral of the story?  Read the ENTIRE MSDN article first!  http://msdn.microsoft.com/en-us/library/ms191432.aspx



Print | posted on Thursday, March 1, 2012 4:34 PM

Feedback

No comments posted yet.

Your comment:





 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski