A Seek Isn’t Always Good Enough
Index seeks are good, right? Normally they are, unless the index that you are seeking against isn’t the correct index. If we look at Figure 1 everything in this plan looks good, right? The cost of the index seek against Table1.Index4 is 0%, the IO cost is very low as is the CPU cost. So […]