Press "Enter" to skip to content

Temp Tables and Plan Cache Pollution

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.