Обсуждение: Count not updated with VACUUM ANALYZE

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

Count not updated with VACUUM ANALYZE

От
Melvin Davidson
Дата:
<div class="Section1"><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">I have statistics enabled on
myserver. However, when I do a VACUUM ANALYZE on my database, the count [ Rows (counted) ] is set to “not
counted”.</span><pclass="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">NowI can right click on the individual tables and select “Count” to manually
updateit, but shouldn’t the VACUUM have done that?</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""> </span><pclass="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Also,is there an documented (or undocumented) function I can run to manually
updatethe counts.</span><p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><p
class="MsoNormal"><spanstyle="font-family:"Arial","sans-serif"">Thanks in advance,</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">MelvinDavidson</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""> </span></div>