Erik Darling requires the vaudeville-style hook:
I solve a lot of problems with #temp tables, indeed I do. And I hate people who are reflexively anti-#temp table.
If you’re into jokes (I’m definitely not into jokes; SQL is serious business), you could even call them #foolish.
Get it?
Click through to see what might cause multiple temp table references in the plan cache.