RE: What database i can use? (fwd)

For those working on INNER/OUTER Joins...any comments? :)

Marc G. Fournier                               scrappy@hub.org
Systems Administrator @ hub.org                    
scrappy@{postgresql|isc}.org                       ICQ#7615664

---------- Forwarded message ----------
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?

> 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. (-: