Re: Force specific plan to be used
From: centrex_at_centrexcc.com <breitliw_at_centrexcc.com>
Date: Thu, 31 Oct 2019 22:06:24 -0600
Message-Id: <6F6FF92D-78FD-479D-9F8B-C8EC4C4D5606_at_centrexcc.com>
Date: Thu, 31 Oct 2019 22:06:24 -0600
Message-Id: <6F6FF92D-78FD-479D-9F8B-C8EC4C4D5606_at_centrexcc.com>
This thread teased me out of retirement ( albeit briefly ). Identical plan_hash_values do NOT mean identical plans or ( by extension ) identical performance. I’ve had a similar situation many years ago and it was ( who else ) Tanel who pointed out where in the plans the difference was despite identical plan_hash_values!!! What goes into the plan_hash_value is only a subset of what makes a plan!!!
> On Oct 31, 2019, at 9:17 PM, Tanel Poder <tanel_at_tanelpoder.com> wrote:
>
> The OP said that the plan hash value didn't change, but since the predicate placement doesn't affect the hash value, it's worth confirming on which plan lines the predicates are applied.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 01 2019 - 05:06:24 CET