Archives of the TeradataForum

Message Posted: Mon, 05 Sep 2011 @ 17:01:53 GMT

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

<-- Anonymously Posted: Monday, September 05, 2011 12:00 -->

Because you have no equality predicates in your join condition, you are stuck with "product join" type behavior.

You don't say how the "IP addresses" are stored. If they are IPv4 dotted-decimal character strings, consider storing the address or at least the high-order octets as numeric types (maybe in addition to the character representations). That can at least make the comparisons more efficient. Note that Teradata does not have native "unsigned" numeric types, so you will need to ensure the values are interpreted as positive, e.g. one octet would need to be SMALLINT.

I would consider putting the high-order 3 octets in an INTEGER field. That also would give you the option of creating a PPI or Value-ordered secondary index, though I doubt those would really help in this situation.

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