Clever Geek Handbook

Performance difference between views and temporary tables

Is there any significant performance difference between the Views and Temporary tables. I like to move data from one database to another. I need to extract raw data from views to tables in destination db.

Since there is no unique field in it, I tried to pull the data from the views into a temporary table and process it to route the data to the destination table. I don't see any significant performance change in terms of timing.

+3


source to share


1 answer


The main difference between temporary tables and views is that temporary tables are only tables in tempdb, but views are just stored queries for existing data in existing tables. This way there is no need to fill out the view because the data is already there. But the temporary table has to be completed first, and the population is the main preparation issue.



+6


source






More articles:


All Articles