Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 10 Jan 2015 @ 17:22:55 GMT

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

Subj:   Re: Restructure large tracking table
From:   Gregg, William

Hi - what is the average number of rows that map to a single NUPI value? What is max, min, and std dev?

If U have too many rows mapped to a typical PI value, the rows begin to flow into multiple blocks negatively impacting performance across the board.

If U have enough rows per month (or whatever time block makes sense) to merit partitioning by time, U may be pleasantly surprised by a partitioning solution.

Good Luck.


Bill Gregg

  <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: 24 Jul 2020