Hi,
Are both fields 'value' in table1 and table2 indexed ?
Regards,
Jocelyn Fournier
----- Original Message -----
From: "Augey Mikus" <amikus@stripped>
To: <mysql@stripped>
Sent: Wednesday, May 08, 2002 4:10 PM
Subject: Unnecessarily long query time
> On one of my MySQL servers (Dell PowerEdge 800Mhz w/ 512MB RAM), I have
> a couple tables that have about 3 million records in each. However some
> of the records in the tables are duplicates of each other. Here is a
> query that should return the number of unique records for both tables:
>
> select count(*) from table1,table2 where table1.value != table2.value;
>
> However, this query has been running for more than 40 hours and still
> has not finished. Is this normal?
>
> Thanks,
>
> Augey
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread108350@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
