1.

How Do You Calculate Record Size Of An Alternate Cluster? Give Your Values For Both Unique And Nonunique?

Answer»

UniqueCase: 5 + (alt-KEY-length + primary - key )
Non UNIQUE Case: 5 + (alt-key-length + n * primary - key ) where n = number of DUPLICATE RECORDS for the alternate key.

UniqueCase: 5 + (alt-key-length + primary - key )
Non unique Case: 5 + (alt-key-length + n * primary - key ) where n = number of duplicate records for the alternate key.


Discussion

No Comment Found

Related InterviewSolutions