-
Contributing Member
Procedures Reg.
Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.
-
Expert Member
Re: Procedures Reg.
>>Stored procedure has precompiled execution Plan
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.
Last edited by krishnaindia2007; 06-04-2008 at 07:08 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules