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 |
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 describe
PROTECTED]
|
| cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
|
| Subject: Re: optimizing left