ow <oneway_111@yahoo.com> writes:
> Am trying to find duplicate values in a large table (about 80M records).
> Somehow, none of the two (2) queries (see below) is using the index "I_bca"
> that, I believe, should've been used.
Those plans are perfectly reasonable (particularly the GroupAggregate one).
regards, tom lane