Results 1 to 2 of 2

Thread: Procedures Reg.

  1. 06-04-2008 #1
    babi_geek
    babi_geek is offline
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Procedures Reg.

    Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.

    Reply With Quote Reply With Quote
  2. 06-04-2008 #2
    krishnaindia2007
    krishnaindia2007 is offline
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact