Extension Index

Most known practice to speed up searches on the standard tables is to create secondary indexes. SAP has introduced a new enhancement technique called Extension index as part of Enhancement Framework. It is same as creating secondary index for the standard table.


Advantage

SAP has already delivered secondary indexes for most of the standard table.  It is not necessary that the existing secondary index fulfill all scenarios. In such cases, creating a secondary index on a standard table comes under modification. During upgrade, they will be deleted and need to be re-created in a system. This involves efforts and cost. Extension indexes are automatically copied over during upgrades and no modification adjustment takes place.


How to create

1. Go to SE11-> Enter table name-> click on Indexes-> Create Extension Index

2.JPG

2. System will display screen same as ‘Creating Secondary Index’.  Enter the required data.

3.JPG

3. Save and activate it. Assign a package and transport request for the extension index.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Kiran K

      Thanks for sharing this new feature in SAP.

      But,in what cases we should choose “Create Extension Index” over the normal Index creation.

      Extension Index getting carried through even during Upgrade is the only advantage ?

      K.Kiran.

      (0) 
      1. Digesh Panchal Post author

        Hi Kiran,

        It is same as creation of secondary index. During upgrade, it will be deleted and need to be re-created in a system. If big list of customer secondary indexes deleted during upgrade, you can imagine the efforts to create them again. If you will not create them, it affects the performance of programs for which they created. Therefore, it is always good to create extension index.

        (0) 

Leave a Reply