Erman Arslan's Oracle Forum
›
Scripting Bash / Sql / Perl
Login
Register
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
Free forum by Nabble
Edit this page