Partitions child tables and analyze

Started by Purchasesabout 6 years ago2 messagesgeneral
Jump to latest
#1Purchases
buy@mark.net

If rows are added, deleted etc from specific child tables of a partition is it necessary when performing an analyze to analyze the entire partition or just the children that experienced the row changes?

#2Ravi Krishna
srkrishna@vivaldi.net
In reply to: Purchases (#1)
Re: Partitions child tables and analyze

If rows are added, deleted etc from specific child tables of a partition is it necessary when performing an analyze to analyze the entire partition or just the children that experienced the row changes?

Under the hood each partition is a separate table, so why is analyzing entire parent table necessary.