FlexPLM で SQL のパフォーマンスが低い場合は、LCSSourceToSeasonLink テーブルにインデックスが必要です

• Oracle レポートで特定されたパフォーマンスの悪い SQL:

SELECT FlexSpecification.branchIditerationInfo, FlexSpecification.idA3masterReference, FlexSpecification.ptc_str_1typeInfoFlexSpecifi, FLEXSPECMASTER.idA2A2, FlexSpecToSeasonLink.idA2A2, SEASONMASTER.idA2A2, FlexSpecification.ptc_str_3typeInfoFlexSpecifi,FlexSpecification.ptc_str_5typeInfoFlexSpecifi, FlexSpecification.ptc_str_2typeInfoFlexSpecifi, FlexSpecification.ptc_str_4typeInfoFlexSpecifi, LCSSOURCINGCONFIG.branchIditerationInfo, LCSSOURCINGCONFIG.idA2A2 
FROM FlexSpecification, FlexSpecMaster FLEXSPECMASTER, FlexSpecToSeasonLink, LCSSeasonMaster SEASONMASTER, lcssourcingconfig_eff LCSSourcingConfig2, lcssourcetoseasonlink_eff LCSSourceToSeasonLink2, lcssourcingconfig_eff LCSSOURCINGCONFIG, LCSSourcingConfigMaster, LCSSourceToSeasonLink 
  WHERE FlexSpecification.idA3masterReference = FLEXSPECMASTER.idA2A2 
    AND SEASONMASTER.idA2A2 = FlexSpecToSeasonLink.idA3B5 
    AND FLEXSPECMASTER.idA2A2 = FlexSpecToSeasonLink.idA3A5 
    AND LCSSourcingConfig2.idA3masterReference = FlexSpecification.idA3B12 
    AND LCSSourcingConfig2.idA3masterReference = LCSSourceToSeasonLink2.sourcingConfigMasterId 
    AND FlexSpecToSeasonLink.idA3B5 = LCSSourceToSeasonLink2.seasonMasterId 
    AND LCSSOURCINGCONFIG.idA3masterReference = LCSSourcingConfigMaster.idA2A2 
    AND LCSSOURCINGCONFIG.idA3masterReference = LCSSourceToSeasonLink.sourcingConfigMasterId 
    AND FlexSpecification.idA3B12 = LCSSourcingConfigMaster.idA2A2 
    AND FlexSpecification.latestiterationInfo = '1' 
    AND FlexSpecification.idA3A12 =:1  
    AND FlexSpecification.idA3B12 = :2  
    AND FlexSpecToSeasonLink.idA3B5 = :3  
    AND ( FlexSpecification.branchIdA2typeDefinitionRefe = :4  ) 
    AND ( LCSSourcingConfig2.branchIdA2typeDefinitionRefe = :5  OR LCSSourcingConfig2.branchIdA2typeDefinitionRefe = :6) 
    AND LCSSOURCINGCONFIG.latestiterationInfo = '1' 
    AND LCSSOURCINGCONFIG.statecheckoutInfo <> 'wrk' 
    AND ( LCSSOURCINGCONFIG.branchIdA3A2typeInfoLCSSourc = :7  OR LCSSOURCINGCONFIG.branchIdA3B2typeInfoLCSSourc = :8  )    
ORDER BY FlexSpecification.ptc_str_1typeInfoFlexSpecifi ASC

SELECT LCSSeason.ptc_str_4typeInfoLCSSeason, LCSSeason.branchIditerationInfo, LCSProductSeasonLink.idA2A2, LCSProductSeasonLink.classnameA2A2, LCSSOURCINGCONFIG.idA3masterReference, LCSSOURCINGCONFIG.idA2A2 
FROM LCSSeason, LCSProductSeasonLink, lcssourcingconfig_eff LCSSOURCINGCONFIG, LCSSourcingConfigMaster, LCSSourceToSeasonLink 
  WHERE LCSProductSeasonLink.idA3B5 = LCSSeason.idA3masterReference 
    AND LCSSeason.idA3masterReference = LCSSourceToSeasonLink.seasonMasterId 
    AND LCSSOURCINGCONFIG.idA3masterReference = LCSSourceToSeasonLink.sourcingConfigMasterId 
    AND LCSSOURCINGCONFIG.idA3masterReference = LCSSourcingConfigMaster.idA2A2 
    AND LCSProductSeasonLink.idA3A5 = LCSSOURCINGCONFIG.placeHolderSKUMasterId 
    AND LCSProductSeasonLink.idA3A5 = :1  
    AND ( LCSProductSeasonLink.seasonRemoved IS NULL  OR LCSProductSeasonLink.seasonRemoved = '0' ) 
    AND LCSProductSeasonLink.effectOutDate IS NULL  
    AND LCSSeason.statecheckoutInfo <> 'wrk' 
    AND LCSSeason.latestiterationInfo = '1' 
    AND LCSSOURCINGCONFIG.latestiterationInfo = '1' 
    AND LCSSOURCINGCONFIG.statecheckoutInfo <> 'wrk' 
    AND ( LCSSOURCINGCONFIG.branchIdA3D2typeInfoLCSSourc = '8546191' OR LCSSOURCINGCONFIG.branchIdA3D2typeInfoLCSSourc = '566264552' OR ...
    AND ( ( LCSSOURCINGCONFIG.ptc_str_16typeInfoLCSSourcin = :2  ) ) 
    AND ( LCSSeason.branchIdA2typeDefinitionRefe = :3 OR LCSSeason.branchIdA2typeDefinitionRefe = :4  ) 
    AND ( LCSProductSeasonLink.branchIdA2typeDefinitionRefe = :5  )    
ORDER BY LCSSeason.ptc_str_4typeInfoLCSSeason ASC