Re: purging old data & index problems?

From: zhu chao <chao_ping_at_vip.163.com>
Date: Sun, 7 Mar 2004 22:37:31 +0800
Message-ID: <000001c404ad$daef0f90$9005a8c0@chaos>

I would suggest using partition to drop the old data. Of course it depends on your application, your table schema, wether it is ok to partition according to current suitable column or add new column.

We used partition to purge the old data and it worked quite good for us.

Regards
Zhu Chao

• Original Message ----- From: Syed Jaffar Hussain To: oracle-l_at_freelists.org Sent: Saturday, March 06, 2004 3:29 PM 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 Sun Mar 07 2004 - 19:34:09 CST