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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-07-28 : 10:23:54
|
| Can someone tell me which ways is better(fast)?1) Select * from view1 WHERE (Orders.ShipCity = N'lyon') view1:SELECT Orders.*, [Order Details].*FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID 2) Here is statement using in one store procedure:SELECT Orders.*, [Order Details].*FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderIDWHERE (Orders.ShipCity = N'lyon') |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-07-28 : 12:01:29
|
| try both in management studio with the execution plan turned on.At a guess I think the execution plans will be identical.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Which way is better? Views or statement?