File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Performance in drop vs truncate
Joined: Nov 15, 2001
Dec 07, 2003 12:23:00
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
Ksh script to export and import from one schema to another
how to delete huge amount of records
narrowing primitive casts
Round for negative nr
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015