Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 18:47:58 GMT


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


Subj:   Re: Cross system queries
 
From:   LeBlanc, James

We have noticed some problems when doing cross system queries. Specifically cross system joins are painful. When joining two tables from two different systems, each row from the first table generates a query to the second system. The resulting activity can be huge. Within a few hours the process generates 100,000's of queries. Seldom do users understand, so consider disallowing cross platform joins and requiring that users load their data and then only perform system local joins.

Jim LeBlanc
NCR/Teradata Technical Account Manager



     
  <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: 15 Jun 2023