union, where and indices (no replies)
(MySQL.com) I have a case in which a UNION is badly optimized, even though the optimization itself should be really simple to derive automatically. Here is an example, which I'm testing on a (Debian stable) MySQL 5.0 (5.0.51a-24+lenny3-log):
CREATE TABLE fir
