on 04-29-2007 6:21 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.