Log Query not using indexes

[benoit plessis]

Hi,

I started using this function to help optimize ours databases servers.
While doing so i found some potentially mis written query, as i expected but
i found queries that could be optimized, expect using un-logical statement.

Example:
a simple table famille:
+-----------------------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-----------------------+------+-----+---------+-------+
| Num_famille | mediumint(8) unsigned | NO | PRI | 0 | |
| Nom_famille | varchar(255) | NO | MUL | | |
+-----------------------+-----------------------+------+-----+---------+-------+

mysql> explain select * from famille;
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
| 1 | SIMPLE | famille | ALL | NULL | NULL | NULL | NULL | 3 | |
+----+-------------+---------+------+---------------+------+---------+------+------+-------+

and running the "select * from famille;" add an entry to the slow log
to get rid of it: "select * from famille where num_famille" or 'num_famille > 0'
but well, it's weird isn't it ?