CODEWITHSUNDEEP
sql-serverviewssisdata-warehouse
Khaled Musaied
Khaled Musaied

Reputation: 2493

Converting Views into tables using SSIS

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?

Upvotes: 0

Views: 1043

Answers (1)

Adam Robinson
Adam Robinson

Reputation: 185593

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.

Upvotes: 3

Related Questions