Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Jun 2004 @ 12:30:03 GMT


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


Subj:   Will the Hash value change?
 
From:   Nazy Gholizadeh

Will changing the format of the index from char(10) to Char(11) change the hash value? For existing records, we will still have the same old value in it(10 characters long), but for some new records(new project) we will need 11 characters. There are other tables having the same field as index as well.

If we change this column to be char(11), will we have to change all the tables? can we keep all the other fact tables as char(10), since their values do not change?

We need to make sure we are not going to create something very inefficient.


.................................................
Nazy Gholizadeh
The Goodyear Tire & Rubber Co. (Dept. 660C)
.................................................



     
  <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: 27 Dec 2016