3 ms·
I 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 memo
by elif 4y ago
I 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.