RE: [EXTERNAL] Re: How to pass hints without modifying SQL code
Date: Wed, 6 Oct 2021 14:45:02 +0000
Message-ID: <CH0PR14MB5012A36E56BAFCFE9E333132E0B09_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Thank you, Franky. I appreciate your quick response. I would like to ask a follow-up question. From the future DB upgrades standpoint, which of the two methods is more reliable or is preferred?
Thanks
From: Franky Weber Faust <weber08weber_at_gmail.com> Sent: Wednesday, October 6, 2021 10:33 AM To: Hameed, Amir <amir.hameed_at_sleepnumber.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: [EXTERNAL] Re: How to pass hints without modifying SQL code
CAUTION: External source
I think SQL Patch is the best way to go: https://sqlmaria.com/2020/02/25/how-to-use-a-sql-plan-baseline-or-a-sql-patch-to-add-optimizer-hints/#more-1121<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsqlmaria.com%2F2020%2F02%2F25%2Fhow-to-use-a-sql-plan-baseline-or-a-sql-patch-to-add-optimizer-hints%2F%23more-1121&data=04%7C01%7Camir.hameed%40sleepnumber.com%7Cc018464517ea49c22a1108d988d64299%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C637691277126658641%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=mQDqfEZKfUSQ%2BbcMZkvUoGT%2FsRpa54wVitRBmRBeVe8%3D&reserved=0>
[LORE DATA]
Franky Weber Faust
Consultor de Banco de Dados | LORE DATA
Oracle ACE ♠️
Fone: 47 99125 2714
Email: franky_at_loredata.com.br<mailto:franky_at_loredata.com.br>
loredata.com.br<https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Floredata.com.br%2F&data=04%7C01%7Camir.hameed%40sleepnumber.com%7Cc018464517ea49c22a1108d988d64299%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C637691277126668601%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=ct0CVPs40KLi%2FUgGnGsqhe6B5sg4jKN9Qj%2F6kDKja%2B8%3D&reserved=0>
On Wed, Oct 6, 2021 at 11:31 AM Hameed, Amir <amir.hameed_at_sleepnumber.com<mailto:amir.hameed_at_sleepnumber.com>> wrote:
Hi,
I am working on optimizing a SQL statement that is part of a COTS/packaged application and therefore, direct code modification is not an option. In this scenario, I am trying to find the most efficient way to pass hints without modifying the code.
Kind regards,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 06 2021 - 16:45:02 CEST