Answered Questions

  • 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.

    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.

    sagyant

    • Oct 3rd, 2010

    what i have come across,it is always 5 + alternate key length + n*primary Key lengththe 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...:)