Extension index

[Former Member]

I am creating some secondary indexes for performance. I see now there is the option of an "extension" index which I do not remmeber since the last time I added some additional indexes. Does anyone know the difference between the normal index option and the extension index option? I am thinking perhaps that the extension index option is the same except that it is not considered a midifcation to the table.

Best regards,

Russ

[Former Member · Accepted solution]

Hi Russ,

you fully hit it ))

The following describes it exactly the way you thought:

http://help.sap.com/saphelp_erp2005/helpdata/EN/85/685a41cdbf8047e10000000a1550b0/content.htm

=> no SPDD, without a key etc ... )

=> You should always use Extension Indexes in future ....

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.net - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

When you create extension index you enhance SAP standard table. It means when you do upgrade SAP into a newer version, SAP does not override your index. You can differentiate extension index and normal index by the "extension index" checkbox of the second column of the index dialog when you click indexes button in SE11.

Hope it helps!