Thread: Partitions child tables and analyze

Partitions child tables and analyze

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


Re: Partitions child tables and analyze

From
Ravi Krishna
Date:
>
> If rows are added, deleted etc from specific child tables of a partition is it necessary when performing an analyze
toanalyze 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.