News for hackers. Stuff that matters.

A comment on A terrible schema from a clueless programmer. Parent comment

Re:A terrible schema from a clueless programmer by ccleve on Sunday November 07, 2021 @11:00AM (#29140522)
It's not an index on every column. It's a single index across all columns.
[ Parent | on HN ]
Re:A terrible schema from a clueless programmer by noisy_boy on Sunday November 07, 2021 @12:07PM (#29141234)
Which will be updated every time there is a new combination.
[ Parent | on HN ]
Re:A terrible schema from a clueless programmer by Animats on Sunday November 07, 2021 @05:04PM (#29143953)
Which is OK. It's not like the whole index has to be rebuilt. It's cheaper than O(log N).
[ Parent | on HN ]