Re: purging old data & index problems?

From: <chris_at_thedunscombes.f2s.com>
Date: Mon, 8 Mar 2004 09:25:29 +0000
Message-ID: <1078737929.404c3c095a4c1@webmail.freedom2surf.net>

Jaffar,  

If you're deleting as opposed to truncating then you need to rebuild the indexes and collect statistics for the tables. If it's a truncate then just collect the stats.  

Chris    

Quoting Syed Jaffar Hussain <sjaffarhussain_at_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
   

Chris Dunscombe  

chris_at_thedunscombes.f2s.com

---

Everyone should have http://www.freedom2surf.net/

---

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 Mon Mar 08 2004 - 03:22:13 CST