MySQL Forums
Forum List  »  UDF

Re: can I use select in UDF?
Posted by: Marion Gordon
Date: August 22, 2014 12:48AM

Hay the following benefits are allowing th UDF functioning. So you can select and use the UDF.

UDF- Benefits of functioning :

They allow modular programming.
You can create the function once, store it in the database, and call it any number of times in your program. User-defined functions can be modified independently of the program source code.

They allow faster execution.
Similar to stored procedures, Transact-SQL user-defined functions reduce the compilation cost of Transact-SQL code by caching the plans and reusing them for repeated executions. This means the user-defined function does not need to be reparsed and reoptimized with each use resulting in much faster execution times.

CLR functions offer significant performance advantage over Transact-SQL functions for computational tasks, string manipulation, and business logic. Transact-SQL functions are better suited for data-access intensive logic.

They can reduce network traffic.
An operation that filters data based on some complex constraint that cannot be expressed in a single scalar expression can be expressed as a function. The function can then invoked in the WHERE clause to reduce the number or rows sent to the client.

Options: ReplyQuote


Subject
Views
Written By
Posted
1947
June 20, 2014 07:28AM
Re: can I use select in UDF?
1314
August 22, 2014 12:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.