1.

Explain Hash Functions In Oracle 7.3?

Answer»

A hash function is a function applied to a cluster key value that returns a hash value. Oracle then uses the hash value to locate the row in the PROPER data block of the hash cluster. The job of a hash function is to provide the maximum distribution of ROWS among the available hash values of the cluster. To ACHIEVE this GOAL, a hash function must minimize the number of collisions.

 

A hash function is a function applied to a cluster key value that returns a hash value. Oracle then uses the hash value to locate the row in the proper data block of the hash cluster. The job of a hash function is to provide the maximum distribution of rows among the available hash values of the cluster. To achieve this goal, a hash function must minimize the number of collisions.

 


Discussion

No Comment Found

Related InterviewSolutions