Re: tkprof

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tkprof-tp8210p8223.html

Besides, you have ROWNUM<=:p_seats in your query.. When you have such rownum clauses in your query, it is normal and expected to see the operations like SORT ORDER BY STOPKEY and COUNT STOP KEY.

See my previous updates for the recommendations about this query's performance.