purging old data & index problems?

From: Syed Jaffar Hussain <sjaffarhussain_at_hotmail.com>
Date: Sat, 6 Mar 2004 10:29:53 +0300
Message-ID: <Law10-OE19I8t2s5YXI000347dc@hotmail.com>

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:44:57 CST