Re: purging old data & index problems?
- From: "zhu chao" <chao_ping@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 7 Mar 2004 22:37:31 +0800
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@xxxxxxxxxxxxx
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
Other related posts:
