Our indexes right now are covering. This makes them super fast for reads, but very expensive for writes. Because of their expense we often avoid using indexes, or too many indexes. I think perhaps this is the wrong tradeoff. We should measure non-covering indexes and see if they are worth switching to.
Our indexes right now are covering. This makes them super fast for reads, but very expensive for writes. Because of their expense we often avoid using indexes, or too many indexes. I think perhaps this is the wrong tradeoff. We should measure non-covering indexes and see if they are worth switching to.