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
Member
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.

Vivek
Re: Temporary tables . Delete or Truncate? [message #65772 is a reply to message #65760] Wed, 22 December 2004 04:46 Go to previous message
Alan
Messages: 68
Registered: October 1999
Member
Hi,
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.

cheers

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


Current Time: Tue Sep 29 07:06:37 CDT 2020