Difference between inline query and stored procedure?
Answer Posted / sudama maharana
1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.
2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.
3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.
4. In stored procedure, we can pass parameters . But in inline query we can't pass.
Thanks
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is primary key clustered index?
Explain the the update statement in sql?
Explain the types of joins in sql?
What is a variable in sql?
Is natural join and inner join same?
How to sort the rows in sql.
Why we use join in sql?
What is cartesian join in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
how do you control the max size of a heap table? : Sql dba
How to assign sql query results to pl sql variables?
What are the three forms of normalization?
Explain the select statement in sql?
What is the difference between the implicit and explicit cursors?
Which are the different types of indexes in sql?