Re: partition performance

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

the problematic sql is the ddl1.txt which is attached in the initial message. 'Explan2' shows the tkprof with 'lower' function in the query and index created using 'lower' function.  This takes 28s

below tkrprof is the output using normal index and 'lower' function removed in query from ddl1.txt. This takes around 1-4s

tkrpfo_normalindex.txt