wood burning stoves 2.0*
The moose likes JDBC and the fly likes Performance in drop vs truncate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Performance in drop vs truncate" Watch "Performance in drop vs truncate" New topic
Author

Performance in drop vs truncate

Brusk Baran
Ranch Hand

Joined: Nov 15, 2001
Posts: 132
i create some temp tables....then:
if I try truncate first and then drop, it seems I have performance gain.
Do you experts advice this?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance in drop vs truncate
 
Similar Threads
Round for negative nr
narrowing primitive casts
Ksh script to export and import from one schema to another
commit command
how to delete huge amount of records