X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 02256475A80 for ; Tue, 15 Apr 2003 11:49:16 -0400 (EDT) Received: from mail.reviewer.co.uk (frodo.reviewer.co.uk [213.232.121.13]) by postgresql.org (Postfix) with SMTP id C3B77474E44 for ; Tue, 15 Apr 2003 11:49:14 -0400 (EDT) Received: (qmail 13965 invoked from network); 15 Apr 2003 15:49:18 -0000 Received: from unknown (HELO LAIKA) (62.49.176.243) by mail.reviewer.co.uk with SMTP; 15 Apr 2003 15:49:18 -0000 From: "Robert John Shepherd" To: Subject: Do Views offer any performance advantage? Date: Tue, 15 Apr 2003 16:49:18 +0100 Message-ID: <001f01c30366$93427720$f3b0313e@LAIKA> 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, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/133 X-Sequence-Number: 1639 Hi all, Whilst I often use views for convenience, is there any performance advantage at all in using a view rather than running the same query directly on the tables themselves? Is it quicker to run a full complex query rather than run a much simpler query on a view? (Hope that makes sense) Yours Unwhettedly, Robert John Shepherd. Editor DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a copy of my Public PGP key, email: pgp@robertsworld.org.uk