delete component reference designators performance issue
Hi experts:
In 12.1.3
In BOM,when delete one component reference designators take 4 min.
DELETE FROM BOM_REFERENCE_DESIGNATORS
WHERE
COMMON_COMPONENT_SEQUENCE_ID = :B2 AND COMPONENT_REFERENCE_DESIGNATOR = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 23.51 237.57 436306 438907 81 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 23.51 237.57 436306 438907 81 0
Create an index , the issue solved.
But we want a patch to solve this issue, Which file need to upgrade to high version can solve this issue?
This script include in which package?
Thanks
Fengling