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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
