Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?
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?
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