knaren1975
asked on
Materialized views
Hi
what is the alternative for Materialized views in Sqlserver 2005.
Thx
Naren
what is the alternative for Materialized views in Sqlserver 2005.
Thx
Naren
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The "alternative" is to simply create a table with the same structure as the view and insert into it from the view, possibly with some sort of dating or other historical indicators if necessary.