Re: partition performance

Posted by Roshan on Oct 30, 2022; 6:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168p11177.html

If I create a functional index on the 'lower' function, I see the query execution time takes 28s instead of 1s. Why does the functional index not work?