Re: purging old data & index problems?

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: