11 ms·
Isn’t this going to make writes very slow, since the index will have to update (and parse the value X times) after insertion?
by ricardobeat 4y ago
Isn’t this going to make writes very slow, since the index will have to update (and parse the value X times) after insertion?
- jitl 4y agoYeah, using expression indexes or generated columns like this is a tradeoff - slower writes for faster queries & more declarative (de)normalization. The same could be said about any index, though… why is this index strategy more concerning? All indexing trades off write speed for read speed.
- keybored 4y agoWhat if you only need to do inserts and never updates?
- remram 4y agoBy "X times" do you mean for each column or when the index is rebuilt?