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.
