Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fine tuning a SPROC
Message
 
 
To
21/06/2007 14:35:20
John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01234693
Message ID:
01234840
Views:
20
>>I replaced my LEFT OUTER JOIN with INNER JOIN, and the query took only 8 seconds this time.
>>
>>LEFT JOIN can always be replaced with INNER JOIN and a UNION. Did both INNER JOINS table1->table2 and table2->table1 work the same?
>
>
>I'm not sure, but that comment doesn't ring true to me. Can you provide an example test to show me what you mean?

http://www.sql-server-performance.com/transact_sql.asp
select table1.*, table2.* from table1 inner join table2 on ...
union ;
select table1.*, cast("" as c(50)) as field2, ... from table1 && rest of records from table1 what don't have table2 matching records
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform