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

Refresh completed. Still not working..

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

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

-- 
Cheers,
Kunwar

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