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.