List:General Discussion« Previous MessageNext Message »
From:Darek Maciera Date:July 10 2012 11:16am
Subject:Fwd: Query take too long time - please help!
View as plain text  
2012/7/10 Ananda Kumar <anandkl@stripped>:
> can u show the explain plan for your query
>

Thanks, for reply!

Sure:

mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
+----+-------------+-------------------------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table                   | type | possible_keys |
key  | key_len | ref  | rows   | Extra       |
+----+-------------+-------------------------+------+---------------+------+---------+------+--------+-------------+
|  1 | SIMPLE      | books                  | ALL  | NULL          |
NULL | NULL    | NULL | 378241 | Using where |
+----+-------------+-------------------------+------+---------------+------+---------+------+--------+-------------+
1 row in set (0.00 sec)
Thread
Fwd: Query take too long time - please help!Darek Maciera10 Jul
  • Re: Query take too long time - please help!Ananda Kumar10 Jul
  • Re: Fwd: Query take too long time - please help!Carsten Pedersen10 Jul
    • RE: Fwd: Query take too long time - please help!Rick James16 Jul