Skip to Content
avatar image
Former Member

Missing Index in DB02

Hi,

When I go to DB02->Diagnostics->Missing Tables and Indexes in our ECC6 system.

I see some missing primary and secondry indexes there.I also see option " Create on Db" there.

Please suggest should I create such indexes by option "Create in Db" and also suggest how SAP find out such missing indexes in Database,,, Does CheckkDB or Update stats provide this information to SAP.

Please confirm.

Regards,

Shivam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 24, 2011 at 08:14 AM

    >

    > Hi,

    >

    > When I go to DB02->Diagnostics->Missing Tables and Indexes in our ECC6 system.

    >

    > I see some missing primary and secondry indexes there.I also see option " Create on Db" there.

    >

    > Please suggest should I create such indexes by option "Create in Db" and also suggest how SAP find out such missing indexes in Database,,, Does CheckkDB or Update stats provide this information to SAP.

    >

    > Please confirm.

    >

    > Regards,

    >

    > Shivam

    Yes you can create them on DB.

    SAP doesnt find out that information until and unless then login into ur system through saprouter.

    Regards,

    Nirmal.K

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2011 at 08:19 AM

    See how many indexes are missing at DB level?

    And check the status of those indexes from SE11, Check why those are not in use?

    Then you will have to create them on your requirement.

    Is your all DB jobs are scheduled and running at DB13?

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2011 at 08:27 AM

    How many indexes are missing in your DB?

    Check the status of those indexes from SE11, Create them at DB level.

    (Check whether these indexes are newly created just)

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded