UDF performance.

Connectivity
Enthusiast

UDF performance.

I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htm
by Dennis Calkins

this function was installed on a database : dbudfdev
and this is how we write our sql

sel dbudfdev.is_integer(col1)
from devdata.table_name

on 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.
1 REPLY
Enthusiast

Re: UDF performance.

I think the first thing to check would be whether you altered the UDF to run on unprotected mode ...

ALTER FUNCTION EXECUTE NOT PROTECTED;