Yes and the reading I have done says you can't create the indexed view when using Outer Joins..... 3 of the 4 views involved use Left Outer Join Isn't that fun for performance.