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?
yah u need to rebuild the indexes after every truncate since the index nodes
will still contain the entries of ur data truncated
"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.
Received on Fri Dec 21 2001 - 01:53:44 CST