3 ms·
Do you also plan to give optimization recommendations for the DB schema itself? I'm thinking more specifically about indexes. In my organization, we provide a
by kakwa_ 5y ago
Do you also plan to give optimization recommendations for the DB schema itself?
I'm thinking more specifically about indexes.
In my organization, we provide a solution where clients can run complex analytic queries periodically. We frequently have to tune the DB manually by adding an index here or there (or just brute force by switching to a bigger RDS...).
A product analyzing the query logs, combined with the estimated size of the tables plus some EXPLAINs run, and then using that to provide index/schema recommendations could help a lot.