thank you ----- Original Message ----- From: "Jay Pipes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Tuesday, March 06, 2007 4:29 AM Subject: Re: help me optimize this "ALL"
> No, because you have no WHERE condition. > > wangxu wrote: >> sql: >> >> SELECT * >> FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = >> table_one.column_two >> INNER JOIN table_one table_one2 ON table_one2.column_one = >> table_one.column_three >> >> >> explain: >> >> *************************** 1. row *************************** >> id: 1 >> select_type: SIMPLE >> table: table_one >> type: ALL >> possible_keys: idx_column_two,idx_column_three >> key: NULL >> key_len: NULL >> ref: NULL >> rows: 2037 >> Extra: >> *************************** 2. row *************************** >> id: 1 >> select_type: SIMPLE >> table: table_one1 >> type: ref >> possible_keys: idx_column_one >> key: idx_column_one >> key_len: 5 >> ref: table_one.column_two >> rows: 1 >> Extra: Using where >> *************************** 3. row *************************** >> id: 1 >> select_type: SIMPLE >> table: table_one2 >> type: ref >> possible_keys: idx_column_one >> key: idx_column_one >> key_len: 5 >> ref: table_one.column_three >> rows: 1 >> Extra: Using where >> >> Can I optimize this "ALL" on table one? >> thanks! >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >