Hi,
I am not sure whether this post should come in this category.
We have approximately 25GB size records spanning 5 tables.Monthly database size increases by 200MB.These records will be useful only for reporting purpose in future.Hence records need to be deleted.Before deletion we are thinking of creating statistics of all the records so that it will be shown in reports.Database is MS SQL 2005.
What needs to be shown in report depends on statistics module.
Does SQL 2005 provides some sort of statistics module or compression utility etc? nre database with different table structure to be created?
Regards
PD

"These records will be useful, so we are going to delete them"?
Huh?

I think he means "archived and THEN deleted". 200MB a month added? It's a very small chunk of data. Have you determined how much data is being modified? Your task at hand should be to aggregate into your reporting database, and then delete from prod. No statistical module in SQL, just a whole slew of ways how to do it, it's up to you

So, by "creating statistics" he is probably not talking about index statistics. He is talking about aggregate statistics on the data.
Seems like this could be created from the archived data as well.