RE: UDF bad performance

Is it showing up as complicated on the plan?

Do you have error checking built into the UDF?

Usually you don't need the begin and end tags in a UDF if it's just a single return statement. Especially one as simple as that calculation.

Michael Salsman

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Friday, May 10, 2019 11:06
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: UDF bad performance

Already set.

-----Original Message-----
From: Salsman, Michael [mailto:Michael.Salsman@xxxxxxxxxxxxxx]
Sent: Friday, May 10, 2019 9:13 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: UDF bad performance

Try defining the function as DETERMINISTIC.

Michael Salsman
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=hDonaBbN0yB2QwQUkSZNQ0BlO_B9286PqbHTOFSLjQc&s=9PLFMeqWx1bZri7rOuTyfJI3x7KzR1GHa3smJGm7QUI&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=hDonaBbN0yB2QwQUkSZNQ0BlO_B9286PqbHTOFSLjQc&s=jNemwVrO2An7g5jaJyldDufvJw6zjrb2cB-1HENsSFs&e= .

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=hDonaBbN0yB2QwQUkSZNQ0BlO_B9286PqbHTOFSLjQc&s=zz7FmvrQo-03aEsCxm1exyemv9uvV-alRn-2Lda_wsI&e=