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,
A database is being used to log support calls for a call center. There are
around 25,000 clients in the database. The existing call notes were imported
from flat text files.
One table (call_notes) contains the call time, ticketid, noteid, ect..
Another table (call_notes_text) only contains
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 order.