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


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.


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: 28 Jun 2020