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

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 --