X hits on this document

120 views

0 shares

0 downloads

0 comments

47 / 48

CHAPTER 28 PERFORMANCE TUNING

For the fourth parameter, since it was not for a stored procedure, function, or trigger, the @module_or_batch parameter was NULL:

@module_or_batch = NULL,

The @params parameter was also sent NULL since this was not a TEMPLATE plan guide: @params = NULL,

The last parameter contained the actual hint to apply to the incoming query—in this case forcing all joins in the query to use a MERGE operation:

@hints = N'OPTION (MERGE JOIN)'

Finally, the sp_control_plan_guide system-stored procedure was used to drop the plan guide from the database, designating the operation of DROP in the first parameter, and the plan guide name in the second parameter.

681

Document info
Document views120
Page views120
Page last viewedFri Dec 09 17:59:03 UTC 2016
Pages48
Paragraphs987
Words15822

Comments