Thanks Gail. For an SP, there can be multiple entries in the dm_exec_query_plan DMV even without SP recompilation is what this implies, right? Will insertion into temp table cause recompilation of SP or only the piece of code where it is queried?

PS: sorry for asking questions when I can find the answers myself. I don't have access to SQL Server right now.