Re: partition performance

Posted by ErmanArslansOracleBlog on Nov 02, 2022; 3:53am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168p11189.html

Roshan,

Send me 2 explain plan for the same query. One with lower function in query and lower function in index, another without them.

I should see the explain plans of both of them and I should see the elapsed times as well.
Then, I will update this issue with my comments.
Multiple files, one with explain other one only query.. It is hard to manage, diagnose... Please send me what I request.