Article - CS301122
Oracle is performing implicit conversion on prodarev.idA312typeInfoLCSProduct for linesheet SQL in FlexPLM 10.2
Modified: 15-Feb-2019
Applies To
- FlexPLM 10.2
Description
- Linesheet query plan shows implicit conversion from VARCHAR2 to NUMBER for idA312typeInfoLCSProduct column in prodarev table:
Predicate Information (identified by operation id):
---------------------------------------------------
17 - filter(("LCSPRODUCT"."IDA312TYPEINFOLCSPRODUCT"=TO_NUMBER(:33) AND
22 - access("T34726119"."IDA2A2"=TO_NUMBER(:33))
---------------------------------------------------
17 - filter(("LCSPRODUCT"."IDA312TYPEINFOLCSPRODUCT"=TO_NUMBER(:33) AND
22 - access("T34726119"."IDA2A2"=TO_NUMBER(:33))
Peeked Binds (identified by position):
--------------------------------------
33 - :33 (VARCHAR2(30), CSID=873): '449982'
- Implict conversion is bad for performance because it could prevent the query from using an index on that column
This is a printer-friendly version of Article 301122 and may be out of date. For the latest version click CS301122