For those people who seek seeks, here’s a “Pro Tip”. Suppose you have a query that involves a Scan. It can be a Clustered Index Scan or an Index Scan, it really doesn’t matter. If it’s a Table Scan, then you have a Heap in play, and this tip doesn’t apply. I’m looking for the […]