Answer Posted / Rishabh Kesarwani
Generally speaking, stored procedures tend to be faster than views because views are essentially SQL queries that are saved as database objects. They are evaluated each time they are accessed, which can lead to performance issues if the query is complex or the data being accessed is large. Stored procedures, however, are precompiled and executed more efficiently.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many tables will create when we create table, what are they? : Sql dba
Is primary key always clustered index?
What is your daily office routine?
Do we need to rebuild index after truncate?
how to escape special characters in sql statements? : Sql dba
What is the current version of postgresql?
what are aggregate and scalar functions? : Sql dba
Is inner join faster than left join?
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
Can delete statement be rollbacked?
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
What is the current version of sql?
If a cursor is open, how can we find in a pl/sql block?
what are all the common sql function? : Sql dba
