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

"krishnananda" <krishna.nanda_at_vwebsol.com> wrote in message news:<9vvt9g$h6b$1_at_news.vsnl.net.in>...
> 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.

krishnananda, when you truncate the table the high-water mark is also reset for the indexes and all extents except the initial extent are returned to free space (unless reuse storage is specified). Oracle does not clean the old, but no longer used blocks, until the blocks are re-allocated to the same or a new object.

• Mark D Powell --