: Query take too long time - please help!
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE
mysql LOWER(ksd)=LOWER('4204661375
Hello,
I have table:
mysql DESCRIBE books;
|id |int(255) | NO | PRI |
NULL | auto_increment |
| idu | int(255) | NO | MUL | NULL
| ksd | char(15) | YES |
can u show the explain plan for your query
On Tue, Jul 10, 2012 at 2:59 PM, Darek Maciera darekmaci...@gmail.comwrote:
Hello,
I have table:
mysql DESCRIBE books;
|id |int(255) | NO | PRI |
NULL | auto_increment |
| idu
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
you are using a function-LOWER, which will not make use of the unique key
index on ksd.
Mysql does not support function based index, hence your query is doing a
FULL TABLE scan and taking more time.
On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera darekmaci...@gmail.comwrote:
2012/7/10 Ananda
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time