Materialized views

Hi

what is the alternative for Materialized views in Sqlserver 2005.

Thx
Naren
knaren1975Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
The "alternative for Materialized views in Sqlserver 2005" is "Indexed view" - please see details below:


http://technet.microsoft.com/en-us/library/cc917715.aspx
0
 
derekkrommCommented:
What exactly are you trying to do?

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.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.