Date: Mon, 27 Dec 1999 10:36:52 +0100 From: "Berend de Boer" <berend@pobox.com> To: "'Marc G. Fournier'" <scrappy@hub.org> Cc: <freebsd-database@FreeBSD.ORG> Subject: RE: What database i can use? Message-ID: <002501bf504d$e917faf0$0321a8c0@bmach.nederware.nl> In-Reply-To: <Pine.BSF.4.21.9912261500560.13180-100000@hub.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?002501bf504d$e917faf0$0321a8c0>