Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, September 5, 2017

Index Seek not possible if you want every row of table, correct?

SQLServerCentral » Latest topics
Index Seek not possible if you want every row of table, correct?
I have a table, it has a clustered index on customer_ID.

I need to return every row of this table via a LEFT join as I want to lookup ALL the customers we have, then join to SALES.(In theory every customer should have a sale, but not in reality)

No comments: