Set Execution plan without modifying the query
Hi Experts,
This is with respect to Index creation - compress option — oracle-mosc.
Original query: ============== UPDATE XXTTD.SVIMS_INV_QTY_STG SET STATUS_FLAG = 'E', STATUS_MSG = 'Duplicate Item Transaction_id' WHERE STAGING_ID IN (SELECT STAGING_ID FROM XXTTD.SVIMS_INV_QTY_STG WHERE STATUS_FLAG = 'N' AND SOURCE = :B2 AND TRANSACTION_ID IN(SELECT ATTRIBUTE15 FROM APPS.MTL_MATERIAL_TRANSACTIONS WHERE TRANSACTION_SOURCE_NAME =:B2 ) AND ITEM = :B1 ) Modified query: =============== We have a added query block alias names and few hints to above query as suggested by kenji. We are not allowed to change the code. How can we fix the plan. Please suggest. Will both the sql's have same sql id? OR will the sql id change after adding the hints and query blocks UPDATE XXTTD.SVIMS_INV_QTY_STG SET STATUS_FLAG = 'E', STATUS_MSG = 'Duplicate Item
0