Home » RDBMS Server » Performance Tuning » Temporary tables . Delete or Truncate?
Temporary tables . Delete or Truncate? [message #65760] Wed, 22 December 2004 03:30 Go to next message
Vivek Vijai
Messages: 67
Registered: April 2004
Truncate or Delete?? which will be the better option for Temporary tables (Create temporary table)??
As in normal table truncate resets the high water mark
and corresponding indexes also gets truncated but Temporary tables are in buffer only they does not have any Physical space so in such case Delete is as good as Truncate??

Please throw some light on it.

Re: Temporary tables . Delete or Truncate? [message #65772 is a reply to message #65760] Wed, 22 December 2004 04:46 Go to previous message
Messages: 68
Registered: October 1999
What is your intention for these temp tables. If you do not need them again then certainly delete them but if you think you might in the future and the columns are not going to change then issue a truncate statement.


Previous Topic: Running many queries in a single shot
Next Topic: What influences cost?
Goto Forum:

Current Time: Tue Jan 31 17:14:33 CST 2023