Hi,
My company had migrated Oracle DB from 11g to 19c. Some queries doesn't run fine with the new version so I used the optimizer_features_enable parameter to shift the behavior of the optimizer backwards to the 11g release. Is posible to run the same query in 19c with 11g execution plan?
Attached are 11g and 19c execution plans.
plan_19c.txt
plan_11g.txt
Thanks in advance.
Regards, Jose Luis