jhager (5/22/2013)
There are (currently) 54 single-use plans with this exact text.
There's a lot of things that could be going on here and it's hard to tell what without a lot more info.
Firstly, sys.dm_exec_query_stats (and sys.dm_exec_procedure_stats) have one row per statement within the procedure, not one row per plan in cache.
You could be seeing statement-level recompiles from the temp table usage.
You could have procedures with different set options (those will result in entire different plans)
Can you post what query it is you're running that shows you multiple plans in cache?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability