> Hi,
> could somebody explain me please why following select
> SELECT docid FROM prod.guids
> GROUP BY docid HAVING( COUNT(docid) > 1 )
>
> taking 15 min on 2 Proc Box on 1M rows, where number of duplicates
> around 300K,
> and docid indexed and not null and char(16).
>
> May be I am doin
Hi,
could somebody explain me please why following select
SELECT docid FROM prod.guids
GROUP BY docid HAVING( COUNT(docid) > 1 )
taking 15 min on 2 Proc Box on 1M rows, where number of duplicates
around 300K,
and docid indexed and not null and char(16).
May be I am doing something wrong?
