Re: Query Problems

[Eric Scuccimarra]

No, we tried individual indexes and then one big grouped index but not 
individual indexes on each of the fields. Adding the index actually added a 
few seconds to the query so we weren't sure if that was the way to go.

I'll try this, though.

Eric

At 10:36 AM 2/25/2004 -0800, Daniel Clark wrote:
Do you have separate indexes on:

 Table1.ID
 Table2.ID
 Table1.Field1
 Table2.Field1
 Table1.Field1
 Table1.Field2
> Select        *
> FROM          Table1 as a
>               INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = 
b.Field1 and
> a.Field2 = b.Field2))
> WHERE bla bla bla
>
> We have tried to set up indexes and the query still takes 8 minutes to
> run.  It only returns 6,000 records.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]