GilaMonster (12/1/2015)
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)
No arguments. This is an edge case to a degree. Couldn't help mentioning it though.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning