5 pts.
 view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?

Software/Hardware used:
ASKED: January 5, 2008  12:13 AM
UPDATED: February 22, 2008  5:35 AM

Answer Wiki:
That will depend on what you are doing. Temp tables and vies are totally different from each other. Typcially views are not stored on disk, and the data have to be queried from the disk. Temp tables take the data that you need into a table in the tempdb database for processing.
Last Wiki Answer Submitted:  January 6, 2008  4:26 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Did my answer help you out any?

 64,550 pts.

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,550 pts.