Re: very slow select with join

2005-01-30 Thread Pavel Novák
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

Re: very slow select with join

2005-01-30 Thread Pavel Novák
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