File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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?
 
wood burning stoves
 
subject: Performance in drop vs truncate