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>
REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name
</pre>
'''Rewriting the query:'''
* Run subsets of the query in order to identify which part is causing the performance problem (isolate joins, remove WHERE clauses, etc.)
* Isolate well performing parts using the WITH clause
* Reformulate WHERE clauses, if possible
* If using '''(NOT) IN''' in a query (and this is identified as the problem), try using '''(NOT) EXISTS''' instead
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:VIE]]