 |
 |
Archives of the TeradataForum
Message Posted: Wed, 03 May 2006 @ 13:25:41 GMT
| 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.
| |
