Earlier this week, Cédric blogged about how easy we can get confused
between a covering index and a full index scan in the
EXPLAIN output. While a covering index (seen with
Extra: Using index) is a
very interesting performance optimization, a full index scan
type: index) is according to the documentation the
2nd worst possible execution plan after a full table scan.
If it is obvious that a full table scan is not good for performance, how much can we expect if we can switch …