Create Indexed Views

An indexed view is a view that has been materialized. This means it has been computed and stored. Indexed views dramatically improve the performance of some types of queries. Indexed views work best for queries that aggregate many rows. They are not well-suited for underlying data sets that are frequently updated

Create the unique clustered index on the view.
CREATE VIEW <View Name>
WITH SCHEMABINDING
AS
SELECT Col1,Col2,Col3
FROM dbo.tablename

Leave a Reply

Your email address will not be published. Required fields are marked *