# 2 статей

Analysis of SQL query optimization in Oracle EBS using EXPLAIN PLAN, where implicit type conversion causes slowdown, and the solution with TO_CHAR for efficient index usage.

I identified the main bottlenecks (repeated XML parsing with xmltype.extract), proposed a fix using `XMLTABLE` and a single, set-based `MERGE`, and included example SQL and index recommendations.