![sql server - Why am I getting Table scan on a partitioned table query? - Database Administrators Stack Exchange sql server - Why am I getting Table scan on a partitioned table query? - Database Administrators Stack Exchange](https://i.stack.imgur.com/dcDFT.png)
sql server - Why am I getting Table scan on a partitioned table query? - Database Administrators Stack Exchange
![Part 3 — Why sometimes Full Table Scan is better than index Scan | by Rehmat Sayany | Westwing Tech Blog Part 3 — Why sometimes Full Table Scan is better than index Scan | by Rehmat Sayany | Westwing Tech Blog](https://miro.medium.com/v2/resize:fit:546/1*klS43GqcpHCmIDDeE7m57g.jpeg)
Part 3 — Why sometimes Full Table Scan is better than index Scan | by Rehmat Sayany | Westwing Tech Blog
![sql server - Why is the optimizer doing a table scan vs Index Seek - Database Administrators Stack Exchange sql server - Why is the optimizer doing a table scan vs Index Seek - Database Administrators Stack Exchange](https://i.stack.imgur.com/Ezs3o.png)
sql server - Why is the optimizer doing a table scan vs Index Seek - Database Administrators Stack Exchange
![SQL SERVER - Force Index Scan on Table - Use No Index to Retrieve the Data - Query Hint - SQL Authority with Pinal Dave SQL SERVER - Force Index Scan on Table - Use No Index to Retrieve the Data - Query Hint - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/noindex.jpg)