For instance, there is one Secondary index - (sap's) A01, which consists of,
for a table.
So, performence point of view, If wanna pull the data from that table,
1) I wanna use this A01, so, Is it mandatory to use all these 3 fields in SELECT statements WHERE codition?
2) or even though If I use the first 2 fields only, this A01 is applicable to my prog./select statement?
3) If I am defining 4 fileds
(one extra field)
in my SELECT statement WHERE condition, but there is A01 with only three fields, In that case I hv to create a new Secondary Indece ZA01 with my 4 fields, Is it correct?
Message was edited by: