using indices with SMALL tables

2016-04-22 Thread Lucio Chiappetti
I am regularly using indices on medium-big tables (1000 to > 5 entries), and even on temporary tables (which I use a lot) in joins (EXPLAIN SELECT is your friend). But I'd never thought indices were needed for small tables (100-200 entries). I recently found they are useful too, and I'd li

Re: utf8 options under Mysql

2016-04-22 Thread Jigal van Hemert
Hi, On 22/04/2016 04:50, Martin Mueller wrote: MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they ca