SQL baseline is not used for one child cursor
Hi,
we had select with nested table with many child cursors and one cursor used a full scans. So we rewrite the query to use CAST not nested table and then we created the baseline. But the baseline still doesn't work. There's still one child cursor without baseline and full scans.
Do you have any idea why is it so?
DB i EE version 11.2.0.4
show parameter optimizer_use_sql_plan_baselines
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
optimizer_use_sql_plan_baselines boolean TRUE
Thank for yours advices.
Thx,
Jana