Is there any difference in optimizing a plan to execute any sql request in case of using a procedure from a package which checks to display row or not and in case of constructing a plain sql query without procedures ?
I mean, should be any difference in sql plans ? And how it might affect the performance of execution.
select * from atbl t where checkme(t.fld) = 1;
select * from atbl t where t.fld = 'OK'
Thank you in advance.