3 ms·
It's possible for sure. The problem is that in such a scenario, there is no requirement or even recommendation for query writers to structure queries with rega
by elif 4y ago
It's possible for sure.
The problem is that in such a scenario, there is no requirement or even recommendation for query writers to structure queries with regard for existing indices. You will rapidly end up with too many partially-overlapping, including the overhead to maintain them.
- marcosdumay 4y agoOn almost every time, this is still a large gain. And on both cases, if you have complete coordination of the developers, you get the same result. You will probably want a "what query uses this index?" feature, that is the other side of the coin of "what indexes make my queries faster?"
- elif 4y agoI think you can afford that perspective until the seek time on indexing becomes slower than your system generates rows or your index size begins to eclipse memory capacity. Having been there, done that, I can assure you more indexes are not always your friend.
- marcosdumay 4y agoWell, if your system is not measuring the cost of the index, and deciding on removing them, than you are correct in that it's useless.