Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

2002-06-10 Thread Matt Rowe
Hi List, I sure do appreciate this list. I'm stumped on the following query: SELECT head.po FROM head LEFT JOIN line ON (head.sn=line.snHead) WHERE head.po 1 AND line.dateETA='2002-06-10' LIMIT 50 As is, this query is very fast (0.01 seconds when

RE: Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

2002-06-10 Thread Matt Rowe
Sorry for the long reply: At 02:57 PM 6/10/2002 -0500, you wrote: [snip] SELECT head.po FROM head LEFT JOIN line ON (head.sn=line.snHead) WHERE head.po 1 AND line.dateETA='2002-06-10' LIMIT 50 As is, this query is very fast (0.01 seconds when there