Changes

Jump to: navigation, search

Optimizing views in pgSQL

230 bytes added, 13:39, 6 August 2014
no edit summary
* Reformulate WHERE clauses, if possible
* If using '''(NOT) IN''' in a query (and this is identified as the problem), try using '''(NOT) EXISTS''' instead
 
== External links ==__NOEDITSECTION__
* http://www.postgresql.org/docs/9.1/static/sql-analyze.html
* http://www.postgresql.org/docs/9.1/static/explicit-joins.html
* http://www.postgresql.org/docs/9.1/static/performance-tips.html
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:VIE]]
1,068
edits

Navigation menu