On 12-07-02 09:33 PM, yoku ts wrote:
Hello,
add index to expression1_id and expression2_id on expression_expression.
it doesn't use index,following,
WHERE
ee2.expression1_id = $ID
OR
ee1.expression2_id = $ID
Thank you for your reply. The table already has indexes on
I don't see an index for expression.id.
-Original Message-
From: brian [mailto:mysql-l...@logi.ca]
Sent: Tuesday, July 03, 2012 12:28 PM
To: mysql@lists.mysql.com
Subject: Re: alternative to slow query
On 12-07-02 09:33 PM, yoku ts wrote:
Hello,
add index to expression1_id and
On 12-07-03 01:13 PM, Stillman, Benjamin wrote:
I don't see an index for expression.id.
mysql db_lexi show index from expression\G
*** 1. row ***
Table: expression
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Not sure why it wouldn't show primary as a possible key then...
From your first email:
*** 1. row ***
id: 1
select_type: SIMPLE
table: e
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
On 12-07-03 02:18 PM, Stillman, Benjamin wrote:
Not sure why it wouldn't show primary as a possible key then...
Yes, that seems rather strange.
From your first email:
*** 1. row ***
id: 1
select_type: SIMPLE