Re: SQL performance on index?


Mih 写道：

Make the index on arbid, mandt, "AUFPL" , "OBJNR" , "APLFL".
This way you will have to scan index with 5 fileds vs. scanning table
with 20+ fields.
The index should be b-tree, because is the combination of 5 fileds is
changing too much for a bitmap index.


Yes, this is what I want. Let the sql just access the index, not a full
table scan.

Another question: the first field of the index should be in where
clause, so it can be ARBID or MANDT, right?

.