SAP Note 770471 - MM_MATNR: Performance problems reading AFVC

Component : Material Master - ArticlesIS-R-BD-PR Seasonal / Promotion PlanningIS-R-BD-SIT

Solution : https://service.sap.com/sap/support/notes/770471 (SAP Service marketplace login required)

Key words :
istru = pt_record_to_delete-matnr            %_hints mssqlnt 'table <, istru = pt_record_to_delete-matnr            %_hints oracle 'index, istru <> lv_istru            %_hints mssqlnt 'table <, #ec ci_nofieldand      select istru werki, table afvc      select single mandt, istru = pt_record_to_delete-matnr            %_hints  db2 ', istru <> ' '            %_hints oracle 'index, optimization'                      db2 '&substitute literals&', optimization'                      db2 '&substitute values&', istru <> lv_istru            %_hints  db2 '

Related Notes :

1009808MM_MATNR: Performance problems during reading of EQUI or OBJ
998448MM_MATNR: Performance problems when reading table AFIH
634197MM_MATNR: Performance improvement for Note 605760
605760MM_MATNR: Performance problems after Note 566984
583206MM_MATNR: Performance problems when reading table AFVC
566984MM_MATNR: missing checks for PM data
162034DB2/390: Database hints in Open SQL
130480Database Hints in Open SQL for Oracle
129385Database hints in Open SQL