Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2002 @ 22:00:04 GMT


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


Subj:   Re: NUPI considerations
 
From:   Claybourne L. Barrineau

Ruth,

Normally, with large tables, I like breaking my queries into smaller pieces. For instance:

-if possible, change PI of 1.5billionrowtable to (NUPI = Col1, Col2) - make sure it is a multiset

-Create multiset keytable1 (NUPI=Col1) which needs to contain the distinct combinations of Col1 and Col2 from 1.5billionrowtable

-Join calendartable (make sure this table is duplicated to all amps in the Explain plan - force it if you have to) and 1.5millionrowtable to keytable1 and stores results in stagtable1 (UPI = calendartable.Col1, 1.5millionrowtable.Col2) including any addition attribute or fact columns needed

-Join 1.5billionrowtable to stagtable1 on Col1,Col2 (should be an AMP local merge join)

If you give me more detail, I might be able to give you a better alternative.


Thanks,

Claybourne Barrineau



     
  <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