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 |
|
evogli
Starting Member
7 Posts |
 Posted - 2012-02-22 : 14:55:58
|
| Hello,I have two tables, CLIENTS (ID INT, FIRSTNAME VARCHAR(50)...)ORDERS (ID INT, ORDERID VARCHAR(20), CLIENTID INT)The CLIENT table has about 1000 rows and the ORDERS table has about 50,000 rows.I can do a INNER JOIN like this:SELECT C.*, O.* FROM CLIENTS C INNER JOIN ORDERS O ON C.ID = O.CLIENTIDOR LIKE THIS:SELECT O.*, C.* FROM ORDERS O INNER JOIN CLIENTS C ON O.CLIENTID = C.IDWhich way does SQL SERVER prefer to give the best performance? Does it make a difference?Thank you. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Inner Join Performance