Hello.
On Wed 2003-01-22 at 09:13:20 +0100, [EMAIL PROTECTED] wrote:
> Steve,
>
> > ([Defendant] Query WITH a join - 8.79 seconds!
> > EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE
> > Cases.CaseNumber = Defendants.CaseNumber AND Filed <= "1999-01-01" AND
> > (Defendant LIKE "
Steve Quezadas wrote:
PS Here is some information about my tables and indexes:
Maybe I missed it, but where's the EXPLAIN on the JOIN query?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---
Steve,
> ([Defendant] Query WITH a join - 8.79 seconds!
> EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE
> Cases.CaseNumber = Defendants.CaseNumber AND Filed <= "1999-01-01" AND
> (Defendant LIKE "owen%" OR Defendant LIKE "pitts%" OR Defendant LIKE
> "general%");
First thing th
