Our production database tables are range partitioned based on date.
Some of the tables and indexes have hundreds of partitions. And some of partitions which are old ( based upon partition key ) have stale statistics. Some of these partitions are most likely not being accessed by our queries.
Sometimes the server exhibits performance problems but we cannot be sure whether the problem is due to those old partitions or not.
Is it a good idea to PROACTIVELY update the statistics in those old partitions ?
Is there a possibility that the performance degrade if we simply update stats on all such partitions ?