SQL: Adding many single column SQL Server indexes is usually counterproductive

added by DotNetKicks
11/23/2018 2:17:26 PM

1 Kicks, 2740 Views

I've just finished delivering a bunch of presentations across New Zealand, and one of the sessions that I've delivered in several places is Things I Wish Developers Knew About SQL Server. In that session, I mentioned briefly that most single column SQL Server indexes that people create are at best pointless, and at worst counterproductive.