News for hackers. Stuff that matters.
Re:Why do database columns have a character length of 191? by TazeTSchnitzel on Monday May 17, 2021 @06:31PM (#27189215)
Prefixes are a neat trick. One nice consequence is that an index for the column pair (a, b) is also an index for (a).
Re:Why do database columns have a character length of 191? by branko_d on Tuesday May 18, 2021 @02:11PM (#27198726)
And if the cardinality of a is low, it can even be an index for b! This is called “skip scan”.

Oracle has supported this for a long time, and apparently newer versions of MySQL as well.

Re:Why do database columns have a character length of 191? by masklinn on Tuesday May 18, 2021 @07:49AM (#27193466)
Yup, also that `like ‘foo%’` can use the index.