Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Need performance help with update
 
From:   Anomy Anom

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