Re: partition performance

Posted by Roshan on Nov 02, 2022; 1:29pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168p11192.html

Hi,

please find below

explain plan of query with lower function and index on lower function.
backdbpp1_ora_4100651_EXPLAN_LOWERFUNC.prf
explain plan of query without lower function and normal index.
backdbpp1_ora_4088817_EXPLAN_NORMALINDEX.prf