I'm looping through a stored procedure - processing 1000 records at a time. I create a #temp table (using dynamic sql so I can't use a table variable from what I saw) When I process those 1000 records, I want to reload. It is more efficient to drop and recreate the table or issue a delete command to remove the existing records?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Efficiency question on temp tables - delete vs drop
- Thread starter DarwinIT
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question