Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Future improvements the optimizer and future join methods wont ever get applied

ChAptEr 23 ■ hintS

Hint Name


MERGE Merge joins are optimal for medium or large tables that are sorted on the joined column.

REMOTE This causes the join to be performed on the server hosting the table that is listed on the right-hand side of the join clause. This hint matters only when a join involves tables sitting on two different servers.

23-2. Forcing a Statement Recompile


SELECT SalesOrderID,
FROM Sales.SalesOrderDetail
WHERE CarrierTrackingNumber = @CarrierTrackingNumber ORDER BY SalesOrderID,

This returns the following:

You may decide that you want to take this recipe’s approach when faced with a query for which query plans are volatile, in which differing search-condition values for the same plan cause extreme fluctuations in the number of rows returned. In such a scenario, using a compiled query plan may hurt, not help, query performance. The benefit of a cached and reusable query execution plan (the avoided cost of compilation) may occasionally be outweighed by the actual poor performance of the query as it is executed using the saved plan.


How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI94481A0
Uploaded by :
Page 1 Preview
future improvements the optimizer and future join
Sell Your Old Documents & Earn Wallet Balance