ow <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
