X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 509C03A4BDC for ; Mon, 15 Nov 2004 23:10:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83713-04 for ; Mon, 15 Nov 2004 23:10:00 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id 2C3553A44DA for ; Mon, 15 Nov 2004 23:10:02 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 40so411675wri for ; Mon, 15 Nov 2004 15:10:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=BaAP3gVcZikldk679TgF8QuMBgjUpru6zUUihdyYZ0c0APeuNt6DKHWp9Va08bgbuWC10Wg/5eJlZX5HDDYtQsvOyHSluEUBmkFOd8w6dTQiK2PVB9oXCphEyqf9NHs5ZhsTw2MoQOCD8W+/YCktd2DgAjOJP5m2XAovLA+nNCE= Received: by 10.54.17.70 with SMTP id 70mr333166wrq; Mon, 15 Nov 2004 15:10:01 -0800 (PST) Received: by 10.54.20.23 with HTTP; Mon, 15 Nov 2004 15:10:01 -0800 (PST) Message-ID: <1dc7f0e3041115151015e34130@mail.gmail.com> Date: Mon, 15 Nov 2004 18:10:01 -0500 From: Alexandre Leclerc Reply-To: Alexandre Leclerc To: PERFORM Subject: Performance difference: SELECT from VIEW or not? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/216 X-Sequence-Number: 9170 I'm just currious about which is the best, if I have many query based on the first one: -- suppose this view (used many times): CREATE VIEW prod.alljobs_view AS SELECT * FROM prod.jobs LEFT JOIN prod.jobs_products ON jobs.job_id = jobs_products.job_id; -- suppose this other query: CREATE VIEW prod.orders_jobs_view AS SELECT job_id, order_id, product_code FROM prod.alljobs_view LEFT JOIN design.products ON alljobs_view.product_id = products.product_id; -- would this be more effective on database side than:? CREATE VIEW prod.orders_jobs_view AS SELECT job_id, order_id, product_code FROM prod.jobs LEFT JOIN prod.jobs_products ON jobs.job_id = jobs_products.job_id LEFT JOIN design.products ON jobs_products.product_id = products.product_id; Which is the best, or is there any difference? (I can't test it myself, I have too few data). Regards. -- Alexandre Leclerc