Hello,
As you know oracle 12c support in memory. we configured this feature.
when check execution plan in some case I don't know why oracle don't use in memory and used index, for example when t.code MB51 run with plant, Movement type ,posting date execution plan fire index ( mseg~0) why oracle !!!
I know oracle is cost base, when invisible indexes, query cost in memory is lower than index cost :(
Please help me. how can I resolve this issue.
Regards.
Ali Mirnia