Can we create indexes on view which has pivot T SQL? [manub22] No you can't create indexed views that involves PIVOT & UNPIVOT operators, check this link: http://msdn.microsoft.com/en-us/library/ms191432.aspx