1.

How Do You Calculate Record Size Of An Alternate Cluster? Give Your Values For Both Unique And Non-unique.

Answer»

Unique Case: 5 + ( alt-key-length + primary-key )
NONUNIQUE Case: 5 + ( alt-key-length + n * primary-key )
where n = # of DUPLICATE records for the alternate key
????Any ONE who KNOWS - can you EXPLAIN ?

Unique Case: 5 + ( alt-key-length + primary-key )
Nonunique Case: 5 + ( alt-key-length + n * primary-key )
where n = # of duplicate records for the alternate key
????Any one who knows - can you explain ?


Discussion

No Comment Found

Related InterviewSolutions