After Creating Index ???

[pr_srinivas]

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 ??

Rdgs

PR

[Former Member · Accepted solution]

Hi,

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