Getting information on cache strategies

To see the cache strategy that is in effect for a given object, execute sp_cachestrategy, with the database and object name:

sp_cachestrategy pubtune, titles
object name      index name       large IO MRU     
---------------- ---------------- -------- --------
titles           NULL             ON       ON 

showplan output shows the cache strategy used for each object, including worktables.