dbcc traceon(302) prints messages if any of the index, I/O size, buffer strategy, or parallel force options are included for a table or if an abstract plan specifying these scan properties was used to optimize the query. Here are sample messages for a query using an abstract plan:
For table ‘titles’: User forces index 2 (index name = type_price_ix) User forces index and data prefetch of 16K User forces MRU buffer replacement strategy on index and data pages User forces parallel strategy. Parallel Degree = 3
