Why does my table value function work faster, when i modify it in SQL server management studio?

Question

I crate a table value function and used it in my c# program.

• When i restart my computer, execute_time for calling this function (in c# program) is 5 minutes.
• But when i just modify this function (without any changes) and then run my program, execute_time is 6 seconds.

Who know that what happen when we modify a function?

What can i do to my execute_time always be 6 seconds?

Answer 1

I had the same problem and finally I had to write a code to edit the SQL function I wanted when starting the C# program.

Answer 2

when you run the first time CPU takes time to figure out how to run a query.SQL Server uses memory to cache execution plans to save time the next time you run the query. source of the information is blog read this blog you will get more info