Post reply

"Real" execution plan for a user-defined function

  • November 15, 2002 at 8:57 am

    #105915

    Is there a way to get the execution plan for a user-defined table function?

    If I turn on the execution plan, I only get the execution plan for the statement: 

    SELECT * FROM dbo.fn_Table_Function(@param)

    It just shows a clustered index scan...I would like to see the execution plan of the function itself.

    -Dan


    -Dan

  • November 15, 2002 at 3:09 pm

    #441534

    You have to take the Sql code from the function and run it in a query window seperately. It doesn't actually have a query plan of its own, but is a wrapper for the code making up the function.

    The results you get should be the same, however, as just running the function and looking at the execution plan from there....

    Edited by - Scorpion_66 on 11/15/2002 3:12:09 PM

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply