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