RE: Do I need to rebuild my indexes?

Truncating the table also truncates the indexes. Hence, no rowid's in the index immediately after truncation.

Jared

On Tue, 26 Sep 2000, LIST, DB wrote:

> I certainly would. The rowid's in the index probably don't match.
> However, analyze index validate structure may work...
>
> Me thinks, anyway
>
> Doug
>
>
>
> -----Original Message-----
> Sent: Tuesday, September 26, 2000 12:51
> To: Multiple recipients of list ORACLE-L
>
> One of our databases has a table with 22 million rows
> in it that got corrupted data in it. In order to fix the corrupted
> data, a temporary table was created, the data was written
> to the temp table, cleansed, the original table was truncated,
> and the clean data was written back to the original table
> pretty much in primary key order.
>
> I think we need to drop and recreate or at least rebuild
> the indexes now that the table has been truncated
> and the data rewritten. A fellow DBA maintains that there
> is no value in doing so. Surely performance will suffer
> if we don't rebuild the indexes. Is this not true? How
> much benefit will be get in dropping and recreating
> the indexes as opposed to rebuilding them as opposed
> to leaving them as is?
>
> Thanks,
>
> Cherie Machler
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: LIST, DB
> INET: DB.LIST_at_bannerhealth.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue Sep 26 2000 - 19:40:37 CDT