Is it a good idea to convert complex views in "db1" into tables in "db2" using SSIS.
the purpose of converting views to tables is to make the reports faster.
Is there any disadvantages or risks?
+3
A:
You would do much better to make your view schema-bound and add indexes as appropriate. Doing this will actually cause SQL Server to make a concrete copy of the view on your server.
For more information, search for "SCHEMABINDING" in this MSDN link.
Adam Robinson
2009-04-24 19:32:32
@Adam: Did you mean to say Indexed Views?
Sung Meister
2009-04-24 19:37:50
Is that not what I said by telling him to add indexes? Making the view schema-bound is a prerequisite of an indexed view (and the most likely restriction you'll have to make a correction for), which is why I said that. You don't create an "indexed view", you create a schema-bound view and add indexes :)
Adam Robinson
2009-04-24 19:46:44
@Adam it cleared up a misconception I had. thanks.
Sung Meister
2009-04-24 20:28:00