Grant Fritchey (12/1/2015)
GilaMonster (11/30/2015)
Welsh Corgi (11/30/2015)
If you have on Index with Column A and another Index with Column A and Column B can't you just have the Index with Both Columns as long as Column A precedes column B of the composite index?Yes
The vast majority of the time. There may be instances where you're seeing scans that the smaller index would be more useful.
True. More common when dealing with the clustered and nonclustered on the same column. I suspect a scan over a 1 or 2 column index would be near identical unless dealing with large column and huge table (billions of rows)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability