Fwd: Query take too long time - please help!

2012/7/10 Ananda Kumar : > can u show the explain plan for your query > Thanks, for reply! Sure: mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375'); ++-+-+--+---+--+-+--++-+ | id | se

Query take too long time - please help!

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 |