From owner-freebsd-database Mon Dec 27 1:42:23 1999 Delivered-To: freebsd-database@freebsd.org Received: from smtp1.xs4all.nl (smtp1.xs4all.nl [194.109.127.48]) by hub.freebsd.org (Postfix) with ESMTP id 620691521E for ; Mon, 27 Dec 1999 01:42:17 -0800 (PST) (envelope-from berend@pobox.com) Received: from auke.nederware.nl (nederware.nl [194.109.55.62]) by smtp1.xs4all.nl (8.9.3/8.9.3) with ESMTP id KAA17595; Mon, 27 Dec 1999 10:42:15 +0100 (CET) Received: from bmach (bmach.nederware.nl [192.168.33.3]) by auke.nederware.nl (8.8.8/8.8.8) with SMTP id KAA07919; Mon, 27 Dec 1999 10:36:56 +0100 (CET) (envelope-from berend@pobox.com) From: "Berend de Boer" To: "'Marc G. Fournier'" Cc: Subject: RE: What database i can use? Date: Mon, 27 Dec 1999 10:36:52 +0100 Message-ID: <002501bf504d$e917faf0$0321a8c0@bmach.nederware.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 In-reply-to: Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > JOIN statement? I take it that this is different then: > > SELECT a.field1, b.field2 from table1 a, table2 b where a.key = b.key ANSI92 supports the far better readable JOIN statement: select a.field1, b.field2 from table1 a join table2 b on a.key = b.key Left outer joins are now easy to: select a.field1, b.field2 from table1 a left outer join table2 b on a.key = b.key It generally parses and optimizes faster too. For MS SQL Server I've seen improvements of up to 75% percent: execution time was the same, but the plan was calculated much faster. Groetjes, Berend. (-: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message