Re: Truncate table, rebuild index?

Andrea wrote:
> hi,
> for some management works i've truncate a table with reuse storage
> option and next i run "insert" for repopulating table with the same
> original data. In this case, is useful to rebuild indexes of the table
> or not?
>
> thanks for your response
>
> bye
>

If all you are doing is trying to "clean up" the index - why not just drop and recreate the index?

What version/platform?
What type of tablespaces are you using? dictionary or local managed?

A more efficient way would be to create another table/index - do a select into from.. order by... then drop current table and rename new table to original table name.

Now, the real question is: What problem are you trying to solve? Received on Mon Sep 03 2007 - 15:35:51 CDT