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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.