Hi,

> Now in 2007, how is Firebird's left-outer-join compared to SQL Server
> 2000/2005 and MySQL 4.x/5.x ? Faster, slower, or about the same?

With normal primary and foreign key relations (which meant using indexes) i expect the behaviour to
be almost the same, but that should also apply to Firebird 1.5. I guess you had a specific LEFT JOIN
that was performing badly, could you give some more details?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info