tuning

Can I Use Statistics to Design Indexes? (Dear SQL DBA Episode 18)

Can I Use Statistics to Design Indexes? (Dear SQL DBA Episode 18)

Should you look at automatically created statistics on your tables in SQL Server to help you design better indexes? Learn why in this 20 minute video, or subscribe to the Dear SQL DBA podcast. No time to watch? Scroll on down, everything is written in article form below the video. Here’s this week’s question: Dear SQL DBA, I’ve noticed that many indexes in my data warehouse aren’t used frequently.