2012/7/10 Ananda Kumar <[email protected]>:
> 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
