On 3 Jun 2002, at 11:49, Stembridge, Michael wrote:

>  FROM 
>   call_notes, 
>   call_notes_text, 
>   users, 
>   facility_contact 
>  WHERE 
>   call_notes.ticketid = '1' && 
>   call_notes.userid = users.userid && 
>   call_notes.contactid = facility_contact.contactid && 
>   call_notes_text.noteid = call_notes.noteid 

I've found that LEFT JOIN can be useful in getting MySQL to process 
tables in the best order.  (It also can make problems with your 
tables more obvious, if records are missing from one of the joined 
tables.)  Try changing that to 

   FROM call_notes c LEFT JOIN call_notes_text ct
        ON c.noteid = ct.noteid
        LEFT JOIN users u ON c.userid = u.userid
        LEFT JOIN facility_contact f
        ON c.contactid = f.contactid
   WHERE c.ticketid = 1

and see how your EXPLAIN result changes.

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to