Обсуждение: Partitions child tables and analyze

Поиск
Список
Период
Сортировка

Partitions child tables and analyze

От
Purchases
Дата:
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

От
Ravi Krishna
Дата:
>
> 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.