Michael,
"Stembridge, Michael" wrote:
>
>
> Finally, I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a
> noteid of 1)
>
> EXPLAIN SELECT
> call_notes.call_elapsed,
> call_notes.call_seconds,
> call_notes.call_start,
>
On 3 Jun 2002, at 22:23, Benjamin Pflugmann wrote:
> You missed to mention that using LEFT JOIN changes the meaning of the
> SELECT in question and it may also be a lot slower, dependend on the
> data.
>
> I think STRAIGHT_JOIN is more appropriate to force the tables to be
> read in a certain or
