Thursday, January 27, 2011

does teradata double checks the data once it gor row hash?

Yes. Once AMP find Row with a given hash value its double checks data for integrity

Ex: Select * from student where sname='suresh';

AMP first check on row hash from PE and once it finds the row , it checks
that row has sname 'suresh' or not

Scary about its hashing ? Its is important for Integrity

No comments:

Post a Comment