Skip to Content

Page Area full after adding index in SE11?

Hi experts.

We just added an index in transaction SE11. Few minutes later our page area was nearly full.


Is there a connection between adding index in SE11 and the page area?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 14, 2016 at 11:19 AM

    Hello Dennis,

    I am not sure about the PAGE but you can follow below note recommendations.


    334224 - Important notes for creating indexes


    Solution

    For creating an index the database may lock the table for insert update and delete operations. Depending on the table size this may lead to performance problems for users performing such operations.
    We recommend that you create the index in your development system, transport it to your quality assurance system and after successful testing transport it to your productive system.
    If your database uses a cost based optimizer the optimizer statistics may need to be updated after the index is created (recent Oracle versions of Oracle do this automatically and db6 will collect statistics automatically when Auto Runstats is enabled).

    • For tables smaller than 100 MB

    The creation is usually done within a few minutes. Therefore, ensure that the table can be locked for such a time period.

    • For tables larger than 100 MB:

    You should find a time frame when the table is not accessed. This could be an R/3 system downtime, or a time when only few online users are logged on and are not working in modules that use the table.

    • For tables larger than 1GB:

    You may need a long time to create the index. Database specific options may be available to accelerate index creation.
    When you want to use a database specific method to accelerate index creations you can use the following method:

    1. 1. Create the index on the Development system using transaction SE11 (ABAP Data Dictionary).

    Note the exact name of the created index.

    1. 2. Create the index with the exact name on the Quality assurance system on database level using the database specific tool (see below).
    2. 3. After the index is successfully created, transport the index to the quality assurance system. This will only transport the ABAP Dictionary information. As the index already exists, it is not created after the transport.
    3. 4. If steps 2. and 3. are successful repeat these steps on the productive system.

    Regards,

    Yuksel AKCINAR

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.