What does the explain look like?
-----Original Message-----
From: Eric Scuccimarra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject: Query Problems
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
The query looks something like this:
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.
Does anyone have any idea what might be the problem and what we can do to
fix it?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
