what is materialized view or summary table and can we use it in sql

[sekar211]

hi

what is materialized view or summary table and can we use it in sql

 

[maswien]

You are sure SQL Server has materialized view? I remember Oracle has it.

 

[JohnDTampaBay]

Materialized views in SQL Server are also referred to as indexed views. SQL Server normally doesn't stored the result set of a view's SELECT statement, just the SELECT. When a clustered index is applied to a view, the SELECT is executed and the result set is stored in the database. The materialized (stored) result set is used when the view is referenced in a query. See BOL, materialized view.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)