Solution : https://service.sap.com/sap/support/notes/380231 (SAP Service marketplace login required)
Summary :
During equipment selection in SAP via view V_EQUI, a performance issue arises due to the database optimizer prioritizing the validity date over more efficient criteria with available indexes, leading to increased runtime. The root cause is identified as a program error. A corrective patch adjusts this by excluding the validity date from the search criteria when filtering for current equipment, maintaining existing functionality for previous times searches.
Key words :
additional key words ie05, database optimizer defines, runtime increases extremely, equipment selection, view v_equi, validity date, selection criteria, program error, solution implement, advance correction
Related Notes :
| 487511 | Performance problem with view V_EQUI |
| 303140 | Techn.object: performance problem f.structure lists |
| 127276 | Performance for structure lists |
| 94143 | Performance problems in structure lists |
| 50610 | Modific. to improve performance in PM struct. lists |