> Please don't hijack threads.
Sorry - did a reply-all to get the address set up; changed the subject but
was working on a few emails at the same time (also posting to the Postgres
newsgroup - their version of the query, on the same machine (with MySQL
stopped) takes 19 seconds with incorrect stat
p
the optimizer. STRAIGHT JOIN can be used in extreme cases where the
optimizer doesn't read the tables in the best order even though you've
listed them that way.
Matt
- Original Message -
From: "Dan Nelson"
Sent: Friday, September 26, 2003 8:11 PM
Subject: Re: Can someo
In the last episode (Sep 26), David Griffiths said:
> - Original Message -
> From: "Mike R. Duncan" <[EMAIL PROTECTED]>
> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, September 25, 2003 2:55 PM
> Subject: RE: Ideas on cre
SELECT count(*)
FROM commercial_entity, country, user_account, address_list
LEFT JOIN state_province ON address_list.state_province_id =
state_province.state_province_id
LEFT JOIN contact_info ON address_list.contact_info_id =
contact_info.contact_info_id
WHERE address_list.address_type_id = 101
AN
