|
| Subject: Re: optimizing left join query
|
>|
Your user_info table is not in
Your user_info table is not indexed...
(user_info.uid should have an index)
Check the manual:
http://www.mysql.com/doc/en/MySQL_indexes.html
On Tue, 2003-02-11 at 16:16, [EMAIL PROTECTED] wrote:
> Hello All,
>
> I have the following 2 tables and "LEFT join" query as follows:
>
>
> mysql> desc
Hello All,
I have the following 2 tables and "LEFT join" query as follows:
mysql> describe user_lic;
+++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+++--+-+-+---+
| license_id | big
