Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: does "truncate table" affect the performace of the associated indexes?
You may also see better overall performance if you drop the indexes prior to
importing the data and recreate them after the load has finished. This way you
can use nologging and parallel systax to speed things up.
"Mark D Powell" <mark.powell_at_eds.com> wrote in message news:178d2795.0112210616.303aa93e_at_posting.google.com...
> Cantonese Boy <waynewan_at_yahoo.com> wrote in message news:<3C22DFB6.BC06AED_at_yahoo.com>...
> > Hi,
> >
> > I have a table which needed to be truncated and re-import data
> > everyday. Do I needed to rebuild the associated indexes to
> > get a better perfermance after each "truncate"?
> > (Will there any performance problem
> > in the indexes tablespace)
> >
> > Thanks for any help
> >
> > W.
>
> 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.
>
> -- Mark D Powell --
-- Posted from d225s229.hotbank.com [63.83.225.229] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Fri Dec 21 2001 - 10:15:52 CST