Plan Forcing Scenarios and Examples

This section contains the following scenarios that show how to use the USE PLAN query hint to match queries with existing query plans by using tempdb and the AdventureWorks2008R2 sample database: