Posted by MH on 08/16/06 17:57

hi everyone !

I am working on a MySQL database version 3.23.58 .

I want to get the customers who have the same email address. Here is what I
did :

SELECT C1.Username, C1.Email, COUNT(*) FROM customer AS C1, customer AS C2
WHERE C1.Email = C2.Email GROUP BY C1.CustomerID HAVING COUNT(*) > 1

The query does its job but is veerryyyyy slow to execute although I have
only 5000 records in my database.

Any idea how to optimize this query ?

Thanks a lot !

MH

• Next in forum: Re: help for opimizing a query
• Prev in forum: Re: php and insert query
• Thread view: help for opimizing a query

[Reply to this message]