NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
</pre>
There will be no visible output of that command, but the database statistics will be refreshed. Freshly updated database statistics can improve the performance of specific queries (especially after big changes - such as after heavy imports - when the automatic statistics gathering process has not yet run).
* Rebuilding the indexes on the affected table(s) used in the problematic query by running the following command (specifying the index or table name):
<pre>
REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name