Temp Table Recompiles

Posted by Derek D. on SQL Server Planet See other posts from SQL Server Planet or by Derek D.
Published on Tue, 30 Mar 2010 06:11:29 +0000 Indexed on 2010/03/30 6:13 UTC
Read the original article Hit count: 352

Filed under:
If you landed on this article, then you most likely know that temp tables can cause recompilation. This happens because temp tables are treated just like regular tables by the SQL Server Engine. When the tables (in which underlying queries rely on) change significantly, SQL Server detects this change (using auto update statistics) [...]

© SQL Server Planet or respective owner

Related posts about SQL Optimization