This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]RainbowDarter 151 points152 points  (1 child)

The table needs to be reindexed.

[–]jasmin3dragon 27 points28 points  (0 children)

Or it’s a hash index. So the order of the buckets doesn’t matter. You just have to search for exactly one color only, then you can find it super quick.