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

I already tried using sql patch , didnt help either. Refreshing dictionary stats to check if that helps.

On Mon, Jun 24, 2019 at 6:33 AM l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> wrote:

> Hi,
>
> i think it would be much easier to use sql_patch.
> Have you tried to refresh dictionary stats though?
>
> Regards
>
> LOthar
>
> ----Ursprüngliche Nachricht----
> Von : krishsingh.111_at_gmail.com
> Datum : 24/06/2019 - 12:23 (MS)
> An : oracle-l_at_freelists.org
> Betreff : How to switch the RULE hint in outlines hints in 12.2 on
> standard edition.
>
> 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