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
---
6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 12:32 AM
Subject: Table joins are slow things to deal with. . .
> Maybe I
Maybe I'm dumb for saying this, but sql joins seems expensive to do in
terms of performance (yes, I indexed the joined fields). If I do a query
search of a 2,600,000 record defendant table WITHOUT a join (SELECT
DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE "owen%" OR
Defendant LIKE