File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Performance in drop vs truncate" Watch "Performance in drop vs truncate" New topic

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:
subject: Performance in drop vs truncate
It's not a secret anymore!