SE11 Inclusion/Exclusion (IE) translastion to Oracle DB

[benoit-schmid]

Hello,

In SE11, for indexes, there is a column Inclusion/Exclusion (IE).

I have not found clear documentation on its usage and impact.

In order to understand its meaning, could you please tell what is performed in the Oracle DB

when IE is selected in se11 for an index?

Thanks in advance for your answer.

[former_member188883 · Accepted solution]

Hi Benoit,

When you create an index using se11 you have two possibilities here:

List of inclusions: The index is only created automatically during activation for the database systems specified in the list. The index is not created on the database for the other database systems.

List of exclusions: The index is not created automatically on the database during activation for the specified database systems. The index is automatically created on the database for the other database systems.

Hope this helps.

Regards,

Deepak Kori

[benoit-schmid · Accepted solution]

Hello Deepak,

Where did you get this info?

Thanks in advance for your answer.

[former_member188883 · Accepted solution]

Hi Benoit,

Its from SAP help

http://help.sap.com/saphelp_40b/helpdata/EN/cf/21eb47446011d189700000e8322d00/content.htm

Regards,

Deepak Kori

[Reagan · Accepted solution]

Hello

Here is the answer:

http://help.sap.com/saphelp_40b/helpdata/EN/cf/21eb47446011d189700000e8322d00/content.htm

Cheers

RB