SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

performance of select statement with function calls

3359542Dec 7 2016 — edited Dec 8 2016

I have a table with around 5 million records for which I need to write a user defined function and call in the select statement.

Is there any way I can improve the performance?

currently trying to create a functional index but not sure if that would be a good idea.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2017

Added on Dec 7 2016

#sql-pl-sql

9 comments

1,641 views