6 messages in com.mysql.lists.mysqlRe: explain| From | Sent On | Attachments |
|---|---|---|
| Hsiu-Hui Tseng | 19 Sep 2003 14:11 | |
| Dathan Vance Pattishall | 19 Sep 2003 14:14 | |
| Jeremy Zawodny | 19 Sep 2003 15:12 | |
| Matt W | 19 Sep 2003 19:17 | |
| Hsiu-Hui Tseng | 19 Sep 2003 22:20 | |
| Jeremy Zawodny | 21 Sep 2003 11:13 |
| Subject: | Re: explain |
|---|---|
| From: | Jeremy Zawodny (Jer...@Zawodny.com) |
| Date: | 09/19/2003 03:12:21 PM |
| List: | com.mysql.lists.mysql |
On Fri, Sep 19, 2003 at 02:12:02PM -0700, Hsiu-Hui Tseng wrote:
Hello,
When I do a explain on a query, I got the following: +-----------------------------------------------------+ | Comment | +-----------------------------------------------------+ | Impossible WHERE noticed after reading const tables | +-----------------------------------------------------+
does this say that my query is using Primary key?
It says that MySQL doesn't believe the query you've asked makes sense.
You could try posting the query here in the hopes that someone will provide a more detailed answer...
Jeremy
-- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <Jer...@Zawodny.com> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 5 days, processed 222,651,539 queries (435/sec. avg)