http://msdn.microsoft.com/en-us/library/ms191432.aspx Microsoft documentation http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx a number of restrictions http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx Creating Indexed Views the documentation http://msdn.microsoft.com/en-us/library/ms191432.aspx all the constraints MSDN http://msdn.microsoft.com/en-us/library/ms191432.aspx MSDN Microsoft documentation http://msdn.microsoft.com/en-us/library/ms191432.aspx indexed view http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx MSDN http://msdn.microsoft.com/en-us/library/ms191432.aspx https://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx http://msdn.microsoft.com/en-us/library/ms191432.aspx MSDN http://msdn.microsoft.com/en-us/library/ms191432.aspx indexed, or materialized, view. MSDN page https://msdn.microsoft.com/en-us/library/ms191432.aspx