Re: Partitions child tables and analyze

2020-01-09 Thread Ravi Krishna
> > 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 paren

Partitions child tables and analyze

2020-01-09 Thread Purchases
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?