I have this query about Secondary index.
What is the use of secondary index in SAP ABAP?
please share your thoughts.
thanks in advance.
If we want to fetch data from a table having large amount of data and if we don't have primary key field value to pass the select query, the query may take more time because of duplicate records and wide search criteria. In that case we will create a secondary for the table with the field which we are using in select query. Secondary index use Binary search technique to compress search criteria.
I hope you understand.
Experts, please correct me if I am wrong.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.