Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: does "truncate table" affect the performace of the associated indexes?

Re: does "truncate table" affect the performace of the associated indexes?

From: Ushkalo Igor <igorus_at_protek.ru>
Date: Fri, 21 Dec 2001 21:14:15 +0300
Message-ID: <3C237BF7.20702@protek.ru>


Mark D Powell wrote:

> Cantonese Boy <waynewan_at_yahoo.com> wrote in message news:<3C22DFB6.BC06AED_at_yahoo.com>...
> Wayne, When you truncate the table the indexes are also truncated.
> When you reload Oracle updates the indexes. As a general rule you are
> good to go though you might want to consider updating the statistics
> immediately after the reload.

I suggest drop indexes before loading, recreate after loading and analyze table compute statistics. It will be nice but maybe more complicated B-)

Received on Fri Dec 21 2001 - 12:14:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US