|
Home > Archive > ASE Database forum > October 2005 > drop table vs. truncate table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
drop table vs. truncate table
|
|
| Jesus M. Salvo Jr. 2005-10-27, 8:21 am |
| ASE 12.5.3 ESD#1
I have a bcp out of a DOL table ... which I want to recreate.
Which is faster ?
1) truncate table ( which "truncate table deallocates whole data pages and
makes fewer log entries" ) .... followed by drop table ?
2) drop table ( which the documentation does not really saw what it does, or
does it simply log the changes in sysobjects, sysxxxx, etc ??? ... what
happens to the page-allocations ? )
| |
| Jeffrey R. Garbus 2005-10-27, 5:29 pm |
| You can always benchmark, but I'd bet they're about the same.
Jeff
"Jesus M. Salvo Jr." <noone@noone.org> wrote in message
news:4355f5c0@forums
-2-dub...
> ASE 12.5.3 ESD#1
>
> I have a bcp out of a DOL table ... which I want to recreate.
>
> Which is faster ?
>
> 1) truncate table ( which "truncate table deallocates whole data pages and
> makes fewer log entries" ) .... followed by drop table ?
>
> 2) drop table ( which the documentation does not really saw what it does,
or
> does it simply log the changes in sysobjects, sysxxxx, etc ??? ... what
> happens to the page-allocations ? )
>
>
>
>
>
>
|
|
|
|
|