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