Page Area full after adding index in SE11?

[denny-k]

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.

[yakcinar · Accepted solution]

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