Guidance - sql tuning
Hi Team,
We are on 19.28 version. We request you if there any recommendations to improve this sql.
-------------------------------------------- SQL_ID 1c1g86jhmbc5g, child number 0 ------------------------------------- SELECT TRANSACTION_ID, TOTAL_COST, ORGANIZATION_ID, INVENTORY_ITEM_ID FROM XXMMS_INV_COST_ITEMS_TBL WHERE (TRANSACTION_ID IN (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 ,
Tagged:
0