When calculating the record size for Alternate index(with duplicates) we use ==> AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates???

venkatesh

• Aug 31st, 2007

 

Its is the apporximate value that is going to be given there. It is not to be correct. I mean it may exceed or it may be less then that