Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aprichard
Yak Posting Veteran
62 Posts |
 Posted - 2009-04-28 : 04:47:27
|
| Hi Every one,Among the given two quries, which provide better performanceSELECT Ename, SalFROM Emp e INNER JOIN Sal s on e.ID=S.IDWHERE e.code=10SELECT Ename, SalFROM Emp e INNER JOIN Sal s on e.ID=S.ID and e.code=10Thanks in Advance |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-04-28 : 04:49:26
|
| check this link lamprey given u descriptionhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124657 |
 |
|
|
|
|
|
Performance