Re: SQL performance on index?

James Yang wrote:
> We found an expensive SQL on our SAP R/3 system:
>
> SELECT
> "AUFPL" , "OBJNR" , "APLFL"
> FROM
> "AFVC"
> WHERE
> "MANDT" = :A0 AND "ARBID" IN ( :A1 , :A2 )#
>
> AUFPL is key for table AFVC. ARBID is defined as an index already.
> OBJNR & APLFL are not defined in any index. Field MANDY & ARBID are
> low-cardinality, but AUFPL is high-cardinality.
>
> If I create a new index which include all those fields (MANDT, ARBID,
> AUFPL, OBJNR, APLFL), will it improve the performance?
>
> B-Tree index or bitmap index is better?
>
> Or, any other good suggestion?
>
> P.S. Storage is not a question for us.
>
> TIA
> James

You do have written permission from SAP to alter the schema? Such actions can invalidate any support agreements your company may have with SAP if done without such a document.

David Fitzjarrell Received on Sun Jun 11 2006 - 04:29:07 CDT