Type All in Explain for Union Query

I am trying to optimize a union query for which the union result is a
type of all, but when each component is explained the types are either
ref or eq_ref. There are quite a few tables and views which form the
bases for the ultimate query, so I don't think posting all of those
would be viable. I am just looking for pointers.
Cirene [ Fr, 11 August 2006 14:50 ] [ ID #1426720 ]
Datenbanken » mailing.database.mysql » Type All in Explain for Union Query

Vorheriges Thema: Replicating part of database
Nächstes Thema: SQL sort (Order by)