2 ms·
Yeah, using expression indexes or generated columns like this is a tradeoff - slower writes for faster queries & more declarative (de)normalization. The same co
by jitl 4y ago
Yeah, 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.