NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
== Summary of recommendations ==__NOEDITSECTION__
Things to check before looking into rewriting the query itself:* Gather database statistics by running the following command on the database:<pre>ANALYZE;</pre>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) by running the following command (specifying the index or table name):<pre>REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name</pre>
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:VIE]]