What is Indexed view in MS SQL Server

Views are also known as virtual table, you can improve performance by creating a unique clustered index on the view.

Using the NOEXPAND View Hint
SELECT Column1, Column2, ... FROM Table1, View1 WITH (NOEXPAND) WHERE




http://msdn.microsoft.com/en-us/library/aa933148(v=SQL.80).aspx