Skip to Content
0
Former Member
Nov 07, 2012 at 02:18 PM

Indexes in ABAP

35 Views

Hi ,

I have a question regarding Indexes ,

We are on ECC 6.0

for example there is a table T1 ---> with index i1 carrying fields a,b,c

and our select on that T1 table consists of fields c,a,b,e,f in the where clause ...

What do u think would be better ?

1) Reorganizing fields in where clause as index i1 .... ? or is it like in ECC 6.0 the order doesnt matter at all ? performance would be the same ??

OR

2) create a new index ? ........ ( fact : we already have 5 indexes made for that table T1 ) would adding more indexes wont cause overhead whenever there is an insert in table T1???

Thanks,

Ethan