Article - CS390238
Full table scans still preferred over applicable indexes even with optimizer_index_cost_adj set correctly in Windchill PDMLink
Modified: 07-Apr-2023
Applies To
- Windchill PDMLink 8.0 to 12.1
- Oracle
Description
- Poorly performing Oracle execution plan does not improve and continues to prefer full table scans over using applicable indexes even after changing optimizer_index_cost_adj from 100 to 10
- Oracle DB report "Full Sql Text And Plans" shows:
-
Note ----- - SQL plan baseline SQL_PLAN_########## used for this statement
This is a printer-friendly version of Article 390238 and may be out of date. For the latest version click CS390238