3 ms·
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 b
by syastrov 6y 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. Even better if it can automatically test the results of that on a production workload.
Or suggest schema changes that would improve normalization or performance.
- zihotki 6y agoRavenDB (1) got you covered but it's a document database. It automatically creates indexes and has a lot of built-in features to improve operability. 1 - https://ravendb.net/features#indexes https://ravendb.net/features#indexes
- thrower123 6y agoThe Azure SQL database services are pretty nifty in this regard.
- kristiandupont 6y agoI wrote a "linter" for database (postgres) schemas. It doesn't currently say anything about indices but I am looking into that because that seems like something that you could make qualified guesses about. github.com/kristiandupont/schemalint/
- BrentOzar 6y 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.
- RussianCow 6y agoIf you're using Postgres, check out dexter[0]. [0]: https://github.com/ankane/dexter https://github.com/ankane/dexter