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 ? Question
Oracle Views, T-SQL, Temp Tables
please tell me which one performs better view or temp table ? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
Browse more Questions and Answers on Oracle and SQL Server.
Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | Feb 22 2008 5:35AM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
