![Temporary Tables and Table Variables in Microsoft SQL Server 2008 T-SQL Programming | Microsoft Press Store Temporary Tables and Table Variables in Microsoft SQL Server 2008 T-SQL Programming | Microsoft Press Store](https://www.microsoftpressstore.com/content/images/chap7_9780735626027/elementLinks/httpatomoreillycomsourcemspimages529621.png)
Temporary Tables and Table Variables in Microsoft SQL Server 2008 T-SQL Programming | Microsoft Press Store
![sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange](https://i.stack.imgur.com/EKl5r.png)
sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange
![SQL SERVER - Table Variables or Temp Tables - Performance Comparison - SELECT - SQL Authority with Pinal Dave SQL SERVER - Table Variables or Temp Tables - Performance Comparison - SELECT - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2019/09/selecttempvars.jpg)