sql server – Index Seek vs Index Scan – Database Administrators Stack Exchange
Posted by jpluimers on 2020/10/01
Below some links I used to get a feel for the different query execution plan entries I observed.
The first one was the most important for me, so hopefully this post helps bump it up in the search engine results.
- [WayBack] sql server – Index Seek vs Index Scan – Database Administrators Stack Exchange covering:
- Table Scans
- Index Scans with Row Lookups
- Index Scans without Row Lookups
- Index Seeks (with or without row lookups)
- Clustered Indexes
- Incomplete Scans
- [WayBack] Clustered Index Seek Showplan Operator | Microsoft Docs
- [WayBack] Clustered Index Scan Showplan Operator | Microsoft Docs
- [WayBack] SQL Server Plans : difference between Index Scan / Index Seek – Stack Overflow via [WayBack] Index Seek vs Index Scan in SQL Server – Stack Overflow
- [WayBack] Scans and Seeks – Craig Freedman’s SQL Server Blog with a truckload of blog posts.
- [WayBack] How b-tree database indexes work and how to tell if they are efficient (100′ level) | mattfleming.com
–jeroen
Leave a comment