Hi,
has anyone ever had a bad exerience with MultiStatement functions?
I've a query that i runs and works fine,if i create a multistatement function of this query, the query runs very slowly ...
The same query in "inline function" hasn't this behavior ... why??
:confused: :confused: :confused: :confused:Where are you using the function in your query?
Your function may be executing once for every row in your result set, possibly thousands of times, and that will of course slow down the query.
Post your code if you would like us to review it.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment