Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 May 2006 @ 13:25:41 GMT


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


Subj:   Re: Distance calcuations
 
From:   Geoffrey Rommel

  Is there a better way? If I have millions of customers and hundreds of stations, it looks very inefficient.  


There doesn't seem to be any way around the product join in the problem as stated, but are there other columns you can use to cheat a little? For instance, if both tables have ZIP codes, you could join where the first digit of the ZIP code matches. This might fail in some odd cases -- for instance, if somebody lives on the edge of a 1xxxx ZIP code but the closest station is actually in 2xxxx -- but would cut down the number of joins considerably.



     
  <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