I am due to partition a large audit table. and will use dbms_stats to analyze the table.

My question is I only want to analyze the active partition and not historically ones (theoritically already analyzed!) or future partitions not yet used.

Just want to analyzed partitions in use!

Any help would be greatly appreciated on how I can do this.

Thanks