Missing Index in DB02

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Nick,

Yes..All DB13 jobs are running in our system..

Regards,

Shivam

[nirmal_konchada]

>

> 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