Archives of the TeradataForum
Message Posted: Mon, 08 Feb 2010 @ 14:33:58 GMT
As you mentioned "T1 has primary index with columns A,B and C"
Please check if there are some duplicate record in T1..
Select A, B, C, COUNT(*) FROM T1 GROUP BY 1, 2, 3 HAVING COUNT(*) > 1
Kapil Dev Sapra
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|