A co-worker has the problem where he has created several functions that he uses in SQL statements. His observation if that these functions, even though light weight, really slows down his SQL. We have speculated that this user-defined function is causing context switches which may be (at least in part) the cause of the slowness.
So, my question is one of general usage hence the lack of an example. Is there some general feature, (compiled code for example) that can be applied to make SQL with embedded user-defined functions run faster? Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
