cancel
Showing results for 
Search instead for 
Did you mean: 

Missing index in DB02

Former Member
0 Kudos

Hi,

i found missing index in de02, i have one solution (in DB13 -- Check and update optimizer statistics ). but it will take long time, any body know how to fix this problem manualy......

Regards,

swathi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Swati

can you be more specific?

what is the version of your SAP system?

Please checl following OSS notes.

For BW system

664034 DB6: DB02 displays missing indexes in APO 30.08.2005

184275 AS/400 Missing Primary Indexes in DB02 04.06.2003

592484 DB02 shows missing indexes in an APO environment 08.03.2004

993410 Primary key is missing in APO E fact table 06.11.2006

157918 BW: DB02 shows "missing indexes" 12.10.2001

For BC

117219 DB02 reports missing DD/DB objects: procedure 05.01.1999

44074 DB02: Display for 'Missing indices' 30.09.1997

129560 Indices missing after successful import w. 30.07.2004

90878 Missing indexes in DB02 02.11.1998

Solution manager:

641659 Short dump when generating Service Report in SolMan 31.07.2003

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi swathi

Just find out if the missing index is a primary index or secondary index> Primary indexes are crtical, secondary indexes are important just for the performance of the system.

Indexes that are defined in the ABAP Dictionary but are missing in the database can be created in the database directly from the display.

Former Member
0 Kudos

Hi,

Are you in Prod? Same situation in other systems?

what kind index of is it? on which table? depending on that, why don't you create it in the database from DB02 itself or via SE14?

hope this helps

Olivier.