How to switch the RULE hint in outlines hints in 12.2 on standard edition.
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Mon, 24 Jun 2019 06:23:28 -0400
Message-ID: <CAJSrDUo4=MPb4TsUdyryMsL355TusdLO_-F-4frPFMmdWXZ8pA_at_mail.gmail.com>
Hi Listers,
I am trying to fix a good plan using outlines. But it doesn't seem to work.
Date: Mon, 24 Jun 2019 06:23:28 -0400
Message-ID: <CAJSrDUo4=MPb4TsUdyryMsL355TusdLO_-F-4frPFMmdWXZ8pA_at_mail.gmail.com>
Hi Listers,
I am trying to fix a good plan using outlines. But it doesn't seem to work.
CREATE OR REPLACE OUTLINE OUTLINE_GOOD ON select /*+ RULE */ COUNT(9) from user_objects;
CREATE OR REPLACE OUTLINE OUTLINE_BAD ON select COUNT(9) from user_objects;
UPDATE OUTLN.OL$HINTS SET OL_NAME = DECODE(OL_NAME, 'OUTLINE_BAD',
'OUTLINE_GOOD', 'OUTLINE_GOOD', 'OUTLINE_BAD')
WHERE OL_NAME IN ('OUTLINE_BAD', 'OUTLINE_GOOD');
COMMIT;
Still query is not using RBO ...or RULE hints . i see costing in the
execution plan.
I am using this note thorougly (Doc ID 2254235.1)
Can you please suggest.
-- Cheers, Kunwar -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 24 2019 - 12:23:28 CEST