SAP ABAP Forum
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