Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 17:24:55 GMT

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

Subj:   Re: Redestributing large tables instead of replicating a small table
From:   David Wellman

Hi Madhukar,

How many amps on your system ? It may be that the number of comparisons is so small compared to a 'real' product join if it moved the small table.

One thing you might want to try as a test is:

- create a copy of your LOCATION table with a different PI (Description columns often give good distribution)

- collect stats on the new table, on both the PI and the LOC_ID column

- re-explain the query and see if the small table is moved.

- check the total estimated time and row count.

You may find that the estimated time is a lot bigger than the 3 minutes and 7 seconds shown below.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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