Score:0

Oracle : Effect of Stale Partition Statistics on Performance

eg flag

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. 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 update the statistics in those old partitions ?

Michael Hampton avatar
cz flag
This question is much more likely to get good answers on our sister site [dba.se].
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.