Skip to Content

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

Rdgs

PR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 17, 2007 at 02:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded