query will be compiled each time excution stored procedure will be compile

Difference between a query and strored procedure?

Question Posted / tathagoto

Answer Posted / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is mariadb nosql?

1036

Are sql database names case sensitive?

997

how can we optimize or increase the speed of a mysql select query? : Sql dba

935

Can we connect to postgresql using sql developer?

994

What is a trigger word?

1015

What is a null value?

1132

what is isam? : Sql dba

998

Can you inner join the same table?

988

What is sap sql?

971

what is union? : Sql dba

1021

Can we write ddl statements in functions?

1107

How can I tell if sql is running?

1053

what is uncommittable transactions? : Transact sql

992

What is sqlerrm?

927

What are the different dml commands in sql?

1165