Re: How to switch the RULE hint in outlines hints in 12.2 on standard edition.
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 25 Jun 2019 09:54:31 -0400
Message-ID: <e4203d33-c30f-38d6-25e6-3f904d6219ec_at_gmail.com>
Date: Tue, 25 Jun 2019 09:54:31 -0400
Message-ID: <e4203d33-c30f-38d6-25e6-3f904d6219ec_at_gmail.com>
Any access plan like hash join or bitmap index, which was not available during late Cretaceous, at the heyday of the RBO, will prevent you from using RBO. KT-boundary, after which no traces of RBO can be found is version 10G.
On 6/24/19 6:23 AM, kunwar singh wrote:
>
> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 25 2019 - 15:54:31 CEST