2 ms·
I think historically people had a lot of bad intuitions about how effective non-composite indexes are in databases. That if I have an index for A and an index f
by hinkley 4y ago
I think historically people had a lot of bad intuitions about how effective non-composite indexes are in databases. That if I have an index for A and an index for B I should be able to do A & B and get a quick answer.
There's been a lot more educational material on composite indexes and in particular partial indexes and so I'm not sure if someone with 3 years' experience today can accurately judge a conversation talking about ten years ago.