| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Do I need to rebuild my indexes?
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-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com]
Sent: Tuesday, September 26, 2000 12:51
To: Multiple recipients of list ORACLE-L
Subject: Do I need to rebuild my indexes?
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 Liststo: 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). Received on Tue Sep 26 2000 - 16:37:31 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |