RE: Do I need to rebuild my indexes?

If you truncated the table data the index data is also truncated. If the = table was defined with an index then when you reloaded the table data the = index would have been created. One method is quickly populating a table is = to drop the index before you populate the table. It is loaded faster and = then create the index. It alows the users to have access to the data but = their selects will be full table scans until the index is fully created. ROR =AA=BF=AA
>>> DB.LIST_at_bannerhealth.com 09/26/00 06:46PM >>>
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=20
--
Author:
  INET: Cherie_Machler_at_gelco.com=20

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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: LIST, DB
  INET: DB.LIST_at_bannerhealth.com=20

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