Archives of the TeradataForum

Message Posted: Mon, 10 Jul 2006 @ 12:42:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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);

Regards,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>