Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

After Creating Index ???

We creating a New Custom Index on MSEG and transported to production?

What are the followup activites to make the usage of created index immediately ??



Former Member replied


Oracle use index after it have been created based on table statistics (CBO)

I suggest you create statistics for this index and update the statistics for the table MSEG.

Use the report RSANAORA, or the transaction DB20.

Best Regards,

Itamar Marioto

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question