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'); +----+-------------+-------------------------+------+---------------+------+---------+------+--------+-------------+ | 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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql