Question

  Asked: Jan 5 2008   0:13 AM GMT
  Asked by: HL


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 ?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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.
  • AddThis Social Bookmark Button

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

Did my answer help you out any?

 

Mrdenny  |   Feb 22 2008  5:35AM GMT

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