in procedure one time compilation is done,whereas in query compilation is

Difference between a query and strored procedure?

Question Posted / khushbu wadhwani

Answer Posted / khushbu wadhwani

in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of index in sql?

1062

Does a primary key have to be a number?

1001

How do I install sql?

1041

Describe different types of general function used in sql?

1088

How much does sqlite cost?

1091

What is the difference between the implicit and explicit cursors?

1103

what is the difference between group by and order by in sql? : Sql dba

1181

What is file based approach?

995

what are sequences

1811

What is the maximum database size for sql express?

1068

what is bcp? When does it used? : Sql dba

1026

What is restrict in sql?

1173

Is postgresql a nosql database?

1220

What is sql*loader?

1276

What is the maximum number of triggers, you can apply on a single table?

1044