Issue with creating tables

#11

Frank van Bortel wrote:

Quote:

laszlo_spamhole (AT) freemail (DOT) hu wrote:

Hmm... actually, I think I see your point. I'm not sure why I'm
dropping the table instead of doing a DELETE FROM, when the data needs
to be recreated from scratch.

Apart from comments pointing towards "you should not be doing this":
a truncate is much faster than a delete from .. However: it is DDL,
not DML

And a global temporary table might eliminate the need to even think
about along with the logging overhead.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Issue with creating tables

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Issue with creating tables - 05-24-2005 , 03:24 PM