Ansi Joins vs. SQL joins

[Angel]

Hi,

Why is it that SQL joins (*=) run a little faster as opposed to ANSI joins(LEFT JOIN...)? Aren't they supposed to be almost identical?

The issue is this: we are promoting using ANSI syntax for the obvious reason (future versions of SQL Server may not support SQL Server syntax; portability, etc.)

However, the problem is the speed. What have others done about this? Do you use ANSI syntax or SQL syntax? HOw true is it that future SQL Server versions may discontinue support for the '*=" and "=*' join operators.

Angel

[Nishant Grover]

I haven't seen any difference in speed between SQL joins and ANSI joins. I prefer using ANSI joins as they are more understandable.

But the statement goes, SQL joins are not going to supported in future releases/versions, one wonders when??

There are many bugs reported on Microsoft's SQL Server site about usage of ANSI joins and the work-around suggested most of the times is to use SQL joins.

Please check them out before taking this step, best of luck!!

-Nishant

------------
Angel at 10/12/99 1:11:29 PM

Hi,

Why is it that SQL joins (*=) run a little faster as opposed to ANSI joins(LEFT JOIN...)? Aren't they supposed to be almost identical?

The issue is this: we are promoting using ANSI syntax for the obvious reason (future versions of SQL Server may not support SQL Server syntax; portability, etc.)

However, the problem is the speed. What have others done about this? Do you use ANSI syntax or SQL syntax? HOw true is it that future SQL Server versions may discontinue support for the '*=" and "=*' join operators.

Angel