ANALYZE command question

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

ANALYZE command question

От:
Igor Stassiy <istassiy@gmail.com>
Дата:
Hi,

Will calling ANALYZE table; twice in a row actually run the command twice ? Or there is some sort of check that if the table is not changed since the time of first call the second command will not actually be run?

Thanks,
Igor

Re: ANALYZE command question

От:
Albe Laurenz <laurenz.albe@wien.gv.at>
Дата:
Igor Stassiy wrote:
> Will calling ANALYZE table; twice in a row actually run the command twice ? Or there is some sort of
> check that if the table is not changed since the time of first call the second command will not
> actually be run?

The statistics will be calculated each time you run ANALYZE.

Yours,
Laurenz Albe
FAQ