Received: from dsh.de (firewall-user@neptun.sns-felb.debis.de [53.122.101.2]) by hub.org (8.9.1/8.9.1) with ESMTP id GAA01889 for ; Wed, 28 Oct 1998 06:27:30 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by dsh.de; id MAA15025; Wed, 28 Oct 1998 12:29:24 +0100 (MET) Received: from dshmail.dsh.de(53.47.15.3) by neptun.dsh.de via smap (3.2) id xma014663; Wed, 28 Oct 98 12:29:07 +0100 Received: from mail1.hh1.dsh.de (mail1.hh1.dsh.de [53.47.9.5]) by dshmail.dsh.de (8.8.7/8.8.7) with ESMTP id MAA16781; Wed, 28 Oct 1998 12:26:18 +0100 (MET) Received: from mars.SAPserv.Hamburg.dsh.de (root@mail5.hh1.dsh.de [53.2.168.17]) by mail1.hh1.dsh.de (8.8.7/8.8.7) with SMTP id MAA29204; Wed, 28 Oct 1998 12:28:48 +0100 Received: from orion.SAPserv.Hamburg.dsh.de by mars.SAPserv.Hamburg.dsh.de with smtp for <> id m0zYRRb-000B5AC; Wed, 28 Oct 98 09:59 MET Received: by orion.SAPserv.Hamburg.dsh.de for pierre@desertmoon.com id m0zYU0C-000EBPC; Wed, 28 Oct 98 12:43 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] Joining bug???? To: caffeine@toodarkpark.org (Howie) Date: Wed, 28 Oct 1998 12:43:00 +0100 (MET) Cc: selkovjr@mcs.anl.gov, pierre@desertmoon.com, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Howie" at Oct 27, 98 06:48:56 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > try making a view. from what others have said, views save the query plan > and have usually, at least for me, been _alot_ faster than normal queries. Views don't save query plans. They are parsetree templates in query rewrite rules. > > --- > Howie URL: http://www.toodarkpark.org > "Oh my god, they killed init! YOU BASTARDS!" Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #