What is the record size for alternate index if alternate key is unique

- whether record size is (5+alternate key length+n*pmy key length ) or (5+pmy key length + n*alternate key length) where 'n' is the no. of duplicate alternate keys.

Questions by kanchhana   answers by kanchhana

Showing Answers 1 - 2 of 2 Answers

sagyant

  • Oct 3rd, 2010
 

what i have come across,it is always 5 + alternate key length + n*primary Key length
the key for alternate index is the alternate key and in the data part we have all the related primary keys populated.

But i still do not understand how this data part get populated...:)

  Was this answer useful?  Yes

naveen

  • Mar 6th, 2017
 

After creating the AI we need to create path and finally we need to create the Build index. Then only the AI will have the actual data in it.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions