RE: purging old data & index problems?

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Sat, 6 Mar 2004 01:59:36 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C0287E73A@uswaumsx14medge.med.ge.com>

We too do that.

We do:

Alter table xyz move tablespace <tsname>; (except the tables that have long/lob columns)

Alter index xyz_idx rebuild nologging (parallel 4); (indexes on the above tables)

Load data

Analyze the tables.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Saturday, March 06, 2004 1:00 PM
To: oracle-l_at_freelists.org
Subject: purging old data & index problems?

Hi List,

During new season at our work we have to purge old data from all tables and keep empty for new season. My question, just rebuilding indexes on those tables is good or just collecting statistics on tables, after purging data, is a good solution?

Rgds
Jaffar

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Sat Mar 06 2004 - 01:57:21 CST