EXPLAIN
FORCE KEY (keyname)
When selecting key, prefer the key with the most selectivity (which can do the largest division of your data).
Article about selectivity (for Oracle, but with general purpose)
MySQL - query planning
Správa článků
Vyhledávání