Archives of the TeradataForum
Message Posted: Mon, 10 Jul 2006 @ 12:42:35 GMT
As you were looking for an instant hint no testing should be allowed, and I have not tested anything.
Try to add n1.COU_ID, n1.ACC_ID and n1.ACG_ID to the SELECT list:
CREATE JOIN INDEX DEVNAD_T.ACCOUNT_JI1, FALLBACK AS SELECT a1.COU_ID, a1.ACC_ID, a1.ACG_ID, n1.NAD_ID, n1.NAM_NM, n1.COU_ID, n1.ACC_ID, n1.ACG_ID FROM DEVNAD_T."ACCOUNT" a1 LEFT JOIN DEVNAD_T.NAD n1 ON ( a1.COU_ID = n1.COU_ID AND a1.ACC_ID = n1.ACC_ID AND a1.ACG_ID = n1.ACG_ID ) PRIMARY INDEX (COU_ID, ACC_ID);
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|