Re: partition performance

Posted by Mustafa Keskin on Nov 03, 2022; 3:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168p11196.html

Hello ,

Dont use functions in where condition at left side , it cause to performance degradation ..

Could you upload actual execution plans in cache  ?

SELECT * FROM TABLE(DBMS_XPLAN.display_cursor(sql_id=>:sql_id ,format =>'ADVANCED'));