> 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.
The data to do this is built into Microsoft SQL Server, and the open source sp_BlitzIndex does exactly what you're asking for.