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).
[ Parent
| on HN ]
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.