Re: EXPLAIN does not explain the WHERE clause

2005-03-01 Thread gerald_clark
Christopher Malton wrote: When I use the statement: EXPLAIN SELECT * FROM workunits WHERE Sent>0 It returns +---+--+---++-++-++ | table | type | possible_keys | key| key_len | ref| rows| Extra | +---

EXPLAIN does not explain the WHERE clause

2005-03-01 Thread Christopher Malton
When I use the statement:   EXPLAIN SELECT * FROM workunits WHERE Sent>0   It returns   +---+--+---++-++-++ | table | type | possible_keys | key    | key_len | ref    | rows    | Extra  | +---+--