Michael Stassen napsal(a):
Is this really your query? The LEFT JOINed tables, editor, customer,
product, brand, calendar, and partner do not contribute to the output
(i.e. none of their columns are selected), nor are they used to
determine which rows to consider (i.e. they don't appear in the W
Jigal van Hemert napsal(a):
| 1 | SIMPLE | o | ALL| NULL | NULL|
NULL | NULL| 20402 | Using temporary; Using
filesort |
Well, this is a clue IMHO... no suitable indexes in o could be found
to use
in this query...
yea, but I use a lot of indexes a