partition performance

Posted by Roshan on Oct 26, 2022; 3:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168.html

Oracle db 19c
Hello Erman,

the query below is taking 28s to execute. Kindly advise how I can improve the execution time?

query1.txt

ddl1.txt
tkprof.txt

Thanks,
Roshan