Archives of the TeradataForum

Message Posted: Tue, 06 Jan 2004 @ 23:09:39 GMT

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

Try simply changing the view to use implicit join instead of INNER JOIN syntax. At least prior to V2R5.1, that can make a big difference.

  ...
FROM OBC_MASTER.LU_OBC_RCONTACT_JOB_ADDNL_INFO REC,
OBC_MASTER.LU_OBC_JOB_INFO RECJOB,
OBC_MASTER.FA_OBC_MDN_MTD RECMTD,
OBC_LOAD.NPA_NXX_OUTBOUND L
  WHERE
RECJOB.JOB_ID = REC.JOB_ID
AND RECMTD.JOB_ID = REC.JOB_ID
AND L.NPANXXX = RECMTD.NPANXXX
AND RECJOB.CONTACT_TYPE = 'R'
AND REC.ORIG_CONTACT_TYPE = 'P'

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