Hash collision?
Answers were Sorted based on User's Feedback
Answer / gowthami
getting the same row hash value for the same row(or) two
different primary index values is called hash collision
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / tdguy
TD uses hashing algorithm to create hash values. Hash value
for a given input is always unique. However as per the
information given by TD, it seems that there are
possibilities that two different PI values can end in same
hash value. This is rare and i hope most of the TD guys
would not have faced it. Such a condition is called
collision.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rahul
Hi gowthami,
what you said its correct,but why don't you try different
answer,it is from mr vinay know..
i don't have clear idea about it.please tell me in very clear
Is This Answer Correct ? | 0 Yes | 1 No |
Increasing no of amps will increase performance. Is this true?
Write a program to show the parser component used in teradata?
What is collect statistics?
Describe the set operators in teradata.
what is differences between Fastload and Multiload as per DBA aspect ?
How do you verify a complicated sql?
How do you determine the number of sessions?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
What is inner join and outer join?
Syntax for case when statement?
write lock is compatiable with which type of lock?
What is the command in bteq to check for session settings ?