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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-13 : 08:33:09
|
| suhasis writes "select A.au_id from Authors as A join titleauthor as TA on A.au_id=Ta.au_idjoin Titles T on TA.title_id=T.title_idmy Question whether 2nd join happens first and on the basis of the selection of the 2nd join First join takes place " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-13 : 08:35:43
|
| You can see the actual query plan in Query Analyzer, using the option under the Query menu.Unlike Oracle, the sequence of the tables in the FROM clause do not matter to SQL Server, the optimizer looks at the entire query when determining the plan. The only way to override this is to use the FORCE ORDER hint, and it is not recommended. For more information, look up "hints" in Books Online. |
 |
|
|
|
|
|
How Join Queries Execute on Multiple Join