Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Treviso (Italy)
    Posts
    17

    Unanswered: Problems with MultiStatement functions

    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??

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •