Indexed View creation

To create indexed view it's the simpler than we cam imaging...

Just add an index on the view:

CREATE UNIQUE CLUSTERED INDEX [IX_V_IndexName] ON [dbo].[MyView]

(

Col1 DESC, 

Col2 DESC

)

GO