This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Performance in drop vs truncate
 
Similar Threads
commit command
narrowing primitive casts
Round for negative nr
Ksh script to export and import from one schema to another
how to delete huge amount of records