Article - CS162866

Oracle cardinality feedback parameter leads to suboptimal SQL execution plan

Modified: 28-Dec-2017   


Applies To

  • Windchill PDMLink 9.1 to 11.0

Description

  • Oracle cardinality feedback parameter leads to suboptimal SQL execution plan
  • Parameter name, cardinality_feedback
  • The parameter is documented in Oracle blog Cardinality Feedback
  • Following lines in Oracle execution plan indicates the plan used cardinality_feedback
     
    Note
    -----
    - cardinality feedback used for this statement
This is a printer-friendly version of Article 162866 and may be out of date. For the latest version click CS162866