December 11, 2012 at 4:03 am
hi friends i have a small doubt in sql plz tell me how to find it which query give more performance
1)select a.empno,a.firstname ,b.deptno,b.location from EMP a,DEPT b where a.deptno =b.deptno
2)
select a.empno,a.firstname ,b.deptno,b.location from EMP a
inner join
DEPT b on a.deptno =b.deptno
an i check estimated execution plan that time both querys are showing
clausterindex scan 50% and cluster index see 50%
how i find it which one is best to write query
ann how we check query performance in sql server
December 11, 2012 at 4:16 am
There will be no difference.
I would advise to use the join keyword as it makes things clearer, stops you missing out a join accidentally and there are things you can do with that syntax that you can't with the abbreviated.
Cursors never.
DTS - only when needed and never to control.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply