Re: fastest way of deleting all rows in a table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 28 Feb 2003 13:38:09 -0000
Message-ID: <b3noof$m5c$1$8300dec7@news.demon.co.uk>

See the Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Search for TRUNCATE, there are two or three articles that should be relevant.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"ShravanaKumar" <shravanakumar.ks_at_siemens.com> wrote in message
news:3E5F61AF.EDCB5E19_at_siemens.com...


> Hi All,

>

> We are using Oracle 9i on Solaris 8.

>

> I would like to know, which is the fastest way of deleting all rows

from


> a table and why ?

>

>     a. Truncate table .....

>     b. delete table .....

>     c. drop table ....  ( an re-create the table afterwards )

>

> can some one shed light on this ?

>

> Thanks,

>

> Best Regards,

> Shravana Kumar.

>

>

>

Received on Fri Feb 28 2003 - 07:38:09 CST