Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id XAA24158 for postgres-dist; Thu, 10 Mar 1994 23:53:59 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199403110753.XAA24158@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from irafs1.ira.uka.de (irafs1.ira.uka.de [129.13.10.100]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id XAA24149 for <postgres@nobozo.cs.berkeley.edu>; Thu, 10 Mar 1994 23:53:57 -0800
Received: from irafs2.ira.uka.de (actually irafs2) by irafs1 with SMTP (PP);
          Fri, 11 Mar 1994 08:50:16 +0000
Received: from iras4.ira.uka.de by irafs2.ira.uka.de with SMTP (PP) 
          id <05058-0@irafs2.ira.uka.de>; Fri, 11 Mar 1994 08:53:23 +0100
To: postgres@postgres.Berkeley.EDU
cc: daub@ira.uka.de
Subject: Re: Hoping the optimiser will consider my index
Date: Fri, 11 Mar 1994 08:50:48 +0100
From: Gerhard Daub <daub@ira.uka.de>
Message-ID: <"irafs2.ira.060:11.02.94.07.53.33"@ira.uka.de>
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 10 Mar 94 23:53:59 -0800
Resent-XMts: smtp

>From Aaron.Roydhouse@Comp.vuw.ac.nz
>  Paul, thanks for your help, perhaps the team should put out an
>  informal `Rules of Engagement' for the postgres optimiser :-) 
>  
>  Is there any other gotchas or query forming advice available?
>  I remember multijoins are better chained that centralised
>  (a = b, b = c is better than a = b, a = b)


I would be very interested in information about the query optimizer, too!


Gerhard