Influencing execution plan via SQL Profiles

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 18 Nov 2016 18:01:19 +0000

Hi,
I am trying to figure out how to remove/nullify existing hints of SQL statement 
and insert different hints without modifying the code:

Original Statement:
UPDATE
    SELECT /*+ leading(aeh,xet,xte) use_hash(xet,xec,xeca) use_nl(xte)
     swap_join_inputs(xet) swap_join_inputs(xec) swap_join_inputs(xeca) */
     aeh.program_update_date -- added hint per performance change 7259699
           ,aeh.program_id
           ,aeh.request_id
           ,aeh.gl_transfer_date
           ,aeh.gl_transfer_status_code
           ,aeh.group_id


TO

Modified statement:
UPDATE
    SELECT /*+ full(xte) parallel(xte,8) */
     aeh.program_update_date -- added hint per performance change 7259699
           ,aeh.program_id
           ,aeh.request_id
           ,aeh.gl_transfer_date
           ,aeh.gl_transfer_status_code
           ,aeh.group_id

This is a packaged application and therefore, it is not possible for us to 
change the code at the moment.

Thanks,
Amir


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2016