Skip to Content
0
Former Member
Apr 26, 2007 at 12:48 PM

Secondary Indeces!

14 Views

Hi Experts,

For instance, there is one Secondary index - (sap's) A01, which consists of,

Field_1

Field_2

Field_3

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?

Field_1

Field_2

Field_3

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

Field_1

Field_2

Field_3

Field_4

(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?

ThaNQ.

Message was edited by:

Sridhar