Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2002 @ 20:19:50 GMT

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

Subj:   Re: NUPI considerations
From:   Al Czajkowski

We do create tables with NUPI/USI fairly often. Our data admins design tables with their use in mind and set PI's to support joining. A synonym chain of a 1000 is long, and I would be concerned if there is much updating of the index fields of either the USI or NUPI. The overhead of maintaining the USI is, to us, a lot cheaper than the reruns if the data gets corrupted by bugs in the transform jobs. In our largest tables, I estimate that more than 50% of the space used is devoted to indexes. That data is very sparse and most non-key columns are compressed/nulls.

Will you need to leave the table in this state for a long time or is this a one time exercise?

Al Czajkowski

  <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