Index in table standard, statistically.

[former_member215246]

Good Morning Anybody !!

I want a help about index in table standard.  After I create a index in stantand table I need to execute statistically ?(Or some other procedure) ???

Regards,

Wagner Duarte

[Former Member]

What do you mean by statistically..?

You need to run db02 (if I'm not wrong) transaction to update the indexes. You need to have DBA rights to do this.

Then you need to check if the newly created index is used using the st05 transaction.

[ThomasZloch]

From SAP DDIC point of view, you create an index via SE11 for the standard table (does not require an access key), activate it and then go to the database utility (via SE11 menu or SE14 directly) to create it on the database as well.

In general, due to the side effects (space and maintenance costs, potentially CBO confusion), create new indexes only after checking other options, like fixing poor SQL statements, using alternative access paths, or if recommended by a SAP note.

Thomas

[former_member215246]

I found the solution !! The correct transaction is DB20 .

Thanks !!!

[custodio_deoliveira]

Hi Wagner,

It's great that you found the solution. Now please close this discussion, will you?

Cheers,

Custodio