Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimization in INNER JOIN
Message
From
07/03/2014 15:19:36
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
07/03/2014 14:48:11
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Title:
Re: Optimization in INNER JOIN
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01595942
Message ID:
01595947
Views:
26
I can get rid of the Probe by including INNER LOOP JOIN. This also makes the execution plan much simpler. But, it this LOOP clause SQL Server only? Is this the proper way to do this?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform