SQL SELECT STATEMENT PERFORMANCE ISSUE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Performance Tuning » SQL SELECT STATEMENT PERFORMANCE ISSUE

SQL SELECT STATEMENT PERFORMANCE ISSUE

Rate Topic

Display Mode

Topic Options

Author

Message

shubham.saxena67

Posted Sunday, January 15, 2012 10:54 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 80, Visits: 202

Dear Friends,

I am having two tables TB_PERSON_P and TB_PERSON_R
both having a common column R_ID
now we can write two query:

select R_ID from TB_PERSON_P P,TB_PERSON_R R where P.R_ID=R.R_ID

and

Select R_ID from TB_PERSON_P P join TB_PERSON_R on P.R_ID=R.R_ID

which would be faster among these two statement?

Thanks!!

Post #1236389

ALZDBA

Posted Monday, January 16, 2012 12:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Monday, June 17, 2013 2:13 PM
Points: 6,866, Visits: 8,071

both will be equal;

However, I always advise to use the join syntax because it nicely distinguishes join conditions and filter conditions.
This is especially interesting with outer joins.
BTW as of sql2005 ( exception trace flag can be enabled ) the old style outer join syntax ( *= , =* ) are no longer supported with sqlserver.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1236402

« Prev Topic | Next Topic »

Permissions