Hello.
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.
Bye,
Benjamin.
On Mon 2002-06-03 at 14:
Hi.
On Mon 2002-06-03 at 14:17:42 -0400, [EMAIL PROTECTED] wrote:
> Try changing your WHERE clause from:
> WHERE
> call_notes.ticketid = '1' &&
> call_notes.userid = users.userid &&
> call_notes.contactid = facility_contact.contactid &&
> call_notes_text.noteid = call_notes.noteid
>
> To
> WHER
ject: 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
>
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.
-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 03, 2002 2:18 PM
> To: Stembridge, Michael; [EMAIL PROTECTED]
> Subject: Re: Sluggish performance on medium sized table.. EXPLAIN
> SELECT's i ncluded.
>
>
> Try changing your WHERE clause from
