X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 30E809257F9 for ; Sat, 31 May 2003 22:52:33 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 84767-01 for ; Sat, 31 May 2003 22:52:22 -0400 (EDT) Received: from TheWorld.com (pcls1.std.com [199.172.62.103]) by developer.postgresql.org (Postfix) with ESMTP id 51AEF921BF2 for ; Sat, 31 May 2003 22:52:22 -0400 (EDT) Received: from trouble (pool-151-203-197-57.bos.east.verizon.net [151.203.197.57]) by TheWorld.com (8.12.8p1/8.12.8) with SMTP id h512qI1L023377 for ; Sat, 31 May 2003 22:52:19 -0400 From: "Brian Tarbox" To: Subject: are views typically any faster/slower than equivilent joins? Date: Sat, 31 May 2003 22:55:18 -0400 Message-ID: <001801c327e9$3c01a5b0$01000001@trouble> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <20030531180235.GF22469@libertyrms.info> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/305 X-Sequence-Number: 2084 I am working with a highly normalized database. Most of my meaningful queries involve joins from a primary table to 4-6 secondary tables. Would my query performance be significantly faster/slower using a View as opposed to a prepared query using join? (Assume all join fields are ints, say 10,000 records in main table and a few dozen records in each of the secondary tables). Thank you. Brian Tarbox