Posted by ehchn1 on 05/20/06 12:08

Hi,

Just curious. Would you use ANSI style table joining or the 'old
fashion' table joining; especially if performance is the main concern?

What I meant is illustrated below:

ANSI Style
select * from a join b on a.id = b.id

Old Style
select * from a, b where a.id = b.id

I noticed that in some SQL, the ANSI is much faster but sometimes, the
old style looks much better.

It's ridiculous to try out both styles to see which is better whenever
we want to write an SQL statement.

Please comment.

Thanks in advance.

• Next in forum: Re: Use ANSI Join or Old Style Join?
• Prev in forum: Re: HW Requirement for SQL Server 2005
• Thread view: Use ANSI Join or Old Style Join?

[Reply to this message]