All Forums Database
14 Aug 2007
UDF performance.

I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htmby Dennis Calkinsthis function was installed on a database : dbudfdevand this is how we write our sqlsel dbudfdev.is_integer(col1)from devdata.table_nameon some big tables it is taking considerably more time to return the answer set.is there a way to improve the response time?Thanks for your help.

Jim Chapman 449 posts Joined 09/04
14 Aug 2007

ALTER FUNCTION dbudfdev.is_integer EXECUTE NOT PROTECTED;In NOT PROTECTED mode, the UDF is loaded and executed directly bythe AMP worker threads.In PROTECTED mode (the default) the UDF is loaded and executed in a special UDF executor process and communicates with the AWT using an IPC mechanism.

You must sign in to leave a comment.