| Temporary tables . Delete or Truncate? [message #65760] |
Wed, 22 December 2004 03:30  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
