Thread: ANALYZE command question

ANALYZE command question

From
Igor Stassiy
Date:
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

From
Albe Laurenz
Date:
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