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 Cherry64,550 pts.