Databases Reference
In-Depth Information
Now, if you execute the stored procedure again, you can verify that it is now using a
Nested Loops Join operator, as shown in the plan in Figure 7-19.
Figure 7-19:
Plan using a plan guide.
In addition, during this execution SQL Server Profiler should capture a
Plan
Guide
Successful
event, showing that SQL Server was able to use the defined plan guide.
The
TextData
column will show the name of the plan guide, which in this case is
plan_guide_test
, as shown in Figure 7-20.
Figure 7-20:
Capturing a
Plan
Guide
Successful
event.