Re: SQL performance on index?

From: James Yang <James.YangGang_at_gmail.com>
Date: 15 Jun 2006 06:43:38 -0700
Message-ID: <1150379018.274942.293540@u72g2000cwu.googlegroups.com>

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? Received on Thu Jun 15 2006 - 08:43:38 CDT