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!