Re: Truncate table, rebuild index?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Mon, 03 Sep 2007 15:03:21 -0700
Message-ID: <1188857001.344843.180240@50g2000hsm.googlegroups.com>

On Sep 3, 6:53 am, Andrea <netsecur..._at_tiscali.it> 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

You truncate the table then put all the original data back?

Why exactly are you doing this? Received on Mon Sep 03 2007 - 17:03:21 CDT