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 PAA06958 for postgres-dist; Wed, 19 Jan 1994 15:23:58 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199401192323.PAA06958@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 raven.native-ed.bc.ca  (raven.native-ed.bc.ca [134.87.106.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA06949 for <postgres@nobozo.CS.Berkeley.EDU>; Wed, 19 Jan 1994 15:23:55 -0800
Received: from localhost (gthomas@localhost) by  raven.native-ed.bc.ca  (8.6.4/8.6.4) id PAA00732 for postgres@postgres.berkeley.edu; Wed, 19 Jan 1994 15:23:28 -0800
Date: Wed, 19 Jan 1994 15:23:28 -0800
From: "Guy R. Thomas" <gthomas@native-ed.bc.ca>
Message-Id: <199401192323.PAA00732@ raven.native-ed.bc.ca >
Received: by NeXT Mailer (1.63)
To: postgres@postgres.Berkeley.EDU
Subject: Execution time of queries ( newbie stuff? )
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Wed, 19 Jan 94 15:23:58 -0800
Resent-XMts: smtp

Just out of curiosity....

Why is there a huge difference in the execution times of these
two queries?

Fast:

  retrieve ( b.oid, b.title, d.oid ) from b in bks1, d in bks1
   where b.title   = d.title
   and     b.oid  != d.oid
  

Slow:

   retrieve ( b.oid, d.oid, b.title ) from b in bks1, d in bks1
      where b.title  =  d.title    

      and     b.oid  != d.oid
     

---
Guy R. Thomas                           Native Education Centre
Library Coordinator                     285 East Fifth Avenue
gthomas@native-ed.bc.ca                 Vancouver B. C.
V:(604) 873-3761 --- F:(604) 873-9152   V5T 1H2

--PAA00721.759021697/ raven.native-ed.bc.ca --