Hacker News new | ask | show | jobs
by BrentOzar 1924 days ago
> I’d like a tool that automatically suggests which indexes to add/remove, including use of different types of indexes and partial indexes, based on the queries being performed

The data to do this is built into Microsoft SQL Server, and the open source sp_BlitzIndex does exactly what you're asking for.