Hacker News Reader

I'm running SQL Databases on Azure SQL, and it gives you recommendations to add indexes, and various other optimizations, that take 1 click to have happen. I get an email, and I can have the index created via a link in my email.

It's pretty fantastic.

View on HN

It based on functionality that all exists in the traditional on-prem SQL Server as well - certainly not the e-mail and point a click creation, but you can definitely query SQL Server DMV's for missing index information[1].

As with any suggested indexes though, they have to be weighed against their effect on other workloads. Additional indexes can have a big impact on inserts / updates / deletes.

[1] https://blogs.msdn.microsoft.com/bartd/2007/07/19/are-you-us...

Definitely true - it can't be mindless, but it's nice that it's put in front of my face w/ no effort.

Reply on news.ycombinator.com