X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2E6B59FA3C0 for ; Tue, 6 Jun 2006 21:05:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29763-04 for ; Tue, 6 Jun 2006 21:05:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grzm.com (grzm.com [200.46.204.98]) by postgresql.org (Postfix) with ESMTP id 564E19FA0E5 for ; Tue, 6 Jun 2006 21:05:30 -0300 (ADT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 689A0161B81E; Wed, 7 Jun 2006 01:05:24 +0100 (BST) In-Reply-To: <1149638001.5283.2.camel@localhost> References: <20060606223309.69534.qmail@web33314.mail.mud.yahoo.com> <1149638001.5283.2.camel@localhost> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <969FFD67-016F-48D5-98C9-BFD5780C8AFB@seespotcode.net> Cc: operationsengineer1@yahoo.com, Burak Seydioglu , pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Join issue Date: Wed, 7 Jun 2006 09:05:21 +0900 To: ken@scottshill.com X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/81 X-Sequence-Number: 25317 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