Materialized View for SQL Server I want to know if there is some thing similar to materialized view for Oracle in SQL Server .

Any ideas ?
A view can be materialised by creating an index on it. There are several preconditions which must be met. These may be tricky to impose on large, established applications with layered views.