Difference between inline query and stored procedure?
Answer Posted / inam abbas
1) stored procedure comes with some major characterstics, as it consists in pre compiled format so the performance increase during dataaccess. incase of simple query it requires to complie again and again as per user request, but here its not required due to precompile format (*compile requires only ones).
2)next it reduce the network traffice so impacts less burden on server and u can integrate it with different front-end applications (e.g. vb.bnet,c#,java etc) inorder to data access.
3)come to next, due to precompile code resides in database server it provides more security and due to complicated queries can be integrated with one form it is portable also.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a record in pl/sql?
What is the process of copying data from table a to table b?
What is auto increment feature in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
How do I truncate a word?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is data manipulation language?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is a nested table in word?
What is the difference between a subquery and a join?
explain the difference between myisam static and myisam dynamic. : Sql dba
Can you have a foreign key without a primary key?
How to run sql statements through the web interface?
What is pl/sql table? Why it is used?
What is sql used for?