Answer Posted / Shashank Braham Dev Narayan
Stored procedures can be faster than SQL queries because they are precompiled, meaning they can reuse the execution plan. This eliminates the need to parse and bind each time the procedure is called, reducing overhead and improving performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
What is the best sql course?
What is your daily office routine?
How do I remove duplicates in two columns?
Can we rollback truncate?
define sql insert statement ? : Sql dba
Is inner join faster than left join?
Is primary key always clustered index?
what is bcp? When does it used? : Sql dba
what are all the common sql function? : Sql dba
Can we use distinct and group by together?
what is schema? : Sql dba
Does group by remove duplicates?
what are aggregate and scalar functions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
