Re: How to switch the RULE hint in outlines hints in 12.2 on standard edition.

Just as a side note outline is getting used.

Note

• outline "OUTLINE_BAD" used for this statement

On Mon, Jun 24, 2019 at 6:23 AM kunwar singh <krishsingh.111_at_gmail.com> wrote:

> 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
>

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l