Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: View Performance
 
From:   Fred W Pluebell

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016