On Jun 7, 2006, at 8:53 , Kenneth B Hill wrote:
Make a "view" with a query, then perform a query using the view, etc. , then drop all views in the SQL script. This may make the entire operation perform faster.
I don't know how using a view would improve performance. However, it may make the overall query more tractable by encapsulating portions of it using views.
Michael Glaesemann grzm seespotcode net ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org