What is Materialized View for SQL Server?
I want to know if there is something similar to materialized view for Oracle in SQL Server. Any ideas?
A view can be materialized by creating an index on it to show SQL server materialized view. There are several preconditions that must be met. These may be tricky to impose on large, established applications with layered views. Hope this helps!