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>