![Why using a local temp table (instead of a global temp table or a regular table) influences the Query Optimizer to choose a poor query plan? - Database Administrators Stack Exchange Why using a local temp table (instead of a global temp table or a regular table) influences the Query Optimizer to choose a poor query plan? - Database Administrators Stack Exchange](https://i.stack.imgur.com/cu9l0.png)
Why using a local temp table (instead of a global temp table or a regular table) influences the Query Optimizer to choose a poor query plan? - Database Administrators Stack Exchange
![SQL SERVER - Interesting Observation - Count of Temporary Table Re-generations - SQL Authority with Pinal Dave SQL SERVER - Interesting Observation - Count of Temporary Table Re-generations - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2017/07/tempnumbergen-800x589.png)
SQL SERVER - Interesting Observation - Count of Temporary Table Re-generations - SQL Authority with Pinal Dave
![Temp Table Filtered Index Creation is Blocked When Stored Procedure is Run Multiple Times Concurrently - Database Administrators Stack Exchange Temp Table Filtered Index Creation is Blocked When Stored Procedure is Run Multiple Times Concurrently - Database Administrators Stack Exchange](https://i.stack.imgur.com/X4eyv.jpg)