JDBC - Pre compile and Sored Procedure

As prepare statement also precompiles the SQL stmt & stored procedure also compiles the stmt once &den execute the same,then what is the diff between these 2 stmts?
  • Interview Candidate
  • 3
  • 4691

Showing Answers 1 - 3 of 3 Answers

Murali100

  • Oct 7th, 2012
 

The difference between these two statements are
1) SQL Query will be compiled every time it is executed. whereas Stored Procedures are compiled only once when they are executed for the first time
2) Stored Procedure is efficient & fast execution than SQL query

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions