Skip to Content
0
Apr 10, 2008 at 05:09 AM

MANDT

41 Views

Hello,

A noob question for you.

Why do most indexes on client specific tables start with MANDT?

Having MANDT at all often seems strange because it nearly always has very low cardinality.

I've read things like "if a table begins with MANDT and the index doesn't then there is a high chance that the index won't be used by the CBO" and "the CBO favours indexes that has the same column order as the fields in the where clause".

Is this true? If so, why?

Is it a mistake to create an index (on a client specific table) that does not have MANDT as the first field?

Regards,

Peter