Thank you Keith - I worked with your example and LEFT JOIN has solved the problem.
Best Regards, Mike > -----Original Message----- > From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 2:26 PM > To: [EMAIL PROTECTED] > Cc: Stembridge, Michael > Subject: Re: Sluggish performance on medium sized table.. EXPLAIN > SELECT's i ncluded. > > > 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
