#59826Better index for sys_language
Description
Hello Core-Team,
I found a better index for sys_language
| 1 | 0.00040700 | SELECT sys_language.* FROM sys_language WHERE sys_language.hidden=0 ORDER BY sys_language.title | | 2 | 0.00024000 | SELECT sys_language.* FROM sys_language WHERE sys_language.hidden=0 ORDER BY sys_language.title |
The sum of ALL cols of sys_language in an UTF-8 environment is 348 Byte. The max. allowed size for an index on a default environment of MySQL is 1024. So why not adding all cols in ONE index? So USING INDEX is also possible.
Stefan