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 NAA17077 for ; Wed, 28 Oct 1998 13:21:57 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by dsh.de; id TAA09576; Wed, 28 Oct 1998 19:24:17 +0100 (MET) Received: from dshmail.dsh.de(53.47.15.3) by neptun.dsh.de via smap (3.2) id xma009351; Wed, 28 Oct 98 19:23:52 +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 TAA15618; Wed, 28 Oct 1998 19:21:07 +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 TAA31791; Wed, 28 Oct 1998 19:23:40 +0100 Received: from orion.SAPserv.Hamburg.dsh.de by mars.SAPserv.Hamburg.dsh.de with smtp for <> id m0zYXvC-000B5AC; Wed, 28 Oct 98 16:54 MET Received: by orion.SAPserv.Hamburg.dsh.de for djackson@cpsgroup.com id m0zYaTp-000EBPC; Wed, 28 Oct 98 19:38 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] Joining bug???? To: djackson@cpsgroup.com (Jackson, DeJuan) Date: Wed, 28 Oct 1998 19:38:00 +0100 (MET) Cc: jwieck@debis.com, caffeine@toodarkpark.org, selkovjr@mcs.anl.gov, pierre@desertmoon.com, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Jackson, DeJuan" at Oct 28, 98 11:49:00 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > But it's interesting. I'll do some tests on it and try to > > find out whether parsing of complicated WHERE clauses is that > > costly that it can be the reason. Seems the rule system is > > quicker than the parser :-) > > > What kind of speed increases are people seeing in their queries? > I've actually never created a view in PostgreSQL (say he with head hung > low). Used a view that is a join of 5 tables. There is absolutely no difference between using the view or the equivalent select from the tables directly in what -s prints as times. There must be something else that causes the speedup reported. Maybe another ordering in the qualifications when using the view. The view qual's are added last to the original queries qual. Putting them the other way round in the query might produce another join order. 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) #