SAP Note 429146 - CC04, CC03: long runtime due to Full Table Scan

Component : Bills of Material -

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

Key words :
analyze table stpo compute statistics, symptom long runtimes occur, additional key words performancecc03, indexed columnsthis statement generates, transaction cc03 -> reporting -> object, structure product browser, structure product browsercs15, respective table index, engineering change managementcc04, examined database select

Related Notes :

1332054Runtime behavior: Displaying/maintaining change numbers
932243Conversion from IPPE to BOM
896972DMU: Deleting document structures w/ transformation matrixes
579851Performance problem using where-used list change number
489419Long runtime for where-used list in bill of material
162034DB2/390: Database hints in Open SQL
130480Database Hints in Open SQL for Oracle
129385Database hints in Open SQL