Home > IT Answers > Oracle > view and temp. table which one works better in T-SQL?
HL
5 pts.
 view and temp. table which one works better in T-SQL?
Oracle Views, T-SQL, Temp Tables
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Did my answer help you out any?

Denny Cherry
 64,550 pts.
 

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

Denny Cherry
 64,550 pts.