Hello ,
I have table directory with 3 columns (id,url,title)
I want to list all entries with duplicate urls.
I tried this:
select id,url,title from directory where url IN
(select url from directory group by url having count(url) > 1)
ORDER by url;
but this takes 30 seconds with 25.000 entries. I have index on url.
Can I use any other query to select this faster.
--
Best regards,
Uros mailto:uros(at)sir-mag(dot)com