Re: maintenance of tables

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 5 Dec 2004 19:45:40 +0100
Message-ID: <41b356ad$0$5180$636a15ce@news.free.fr>

"Giuseppe R." <giusepper_at_tiscali.it> a écrit dans le message de news:covcl0$lrn$1_at_lacerta.tiscalinet.it...
> Dear all,
> truncating a table deletes all row in a table, (I don't find this) and will
> be or not to be the correspondig indexes truncated?
> Tank to all
>
>
>

From SQL Reference, TRUNCATE page:

"When you truncate a table, Oracle automatically removes all data in the table's indexes..."

Regards
Michel Cadot Received on Sun Dec 05 2004 - 12:45:40 CST