Solution : https://service.sap.com/sap/support/notes/157918 (SAP Service marketplace login required)
Summary :
This SAP Note addresses missing index detection discrepancies in DB02 for fact tables within SAP BW systems. Indexes with specific prefixes are mistakenly reported as absent by DB02, despite their presence or substitution on the database. The issue arises due to native SQL features adopted for performance enhancement in BW systems, which bypass the standard R/3 data dictionary, leading to inconsistent information. Solutions vary depending on the BW and Oracle version, ranging from direct database checks to using specific SAP transactions and reports to validate or repair the index statuses. For non-Oracle databases in newer BW versions, analogous verification methods are advised, along with maintenance reports to reconcile the DB02 display with actual database configurations.
Key words :
additional key words business information warehouse, patch level 11 make db02 consistent, triggering native sql statements, parallel index building facilities, symptom db02 shows indexes, aggregate cubes fact tables, oracle-based bw systems, 0b patch 3 onwards, database level show, traffic light semantics
Related Notes :
| 427826 | Error during the index handling of APO InfoCubes in BW 2.x |
| 422320 | E fact table indexes are deleted but not repaired |
| 401242 | Problems with InfoCube or aggregate indexes |
| 217397 | Indexing Scheme of BW facttables under Oracle |
| 210888 | BPS0: Termination, performance problems when saving |