Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.
Printable View
Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.
[B]>>Stored procedure has precompiled execution Plan [/B]
SQL statements implemented as a part of stored procedures has pre compiled Execution plans and are stored in the database, together with the procedure. This can remove the compilation overhead that is typically required in situations where software applications send inline SQL queries to a database.