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
Do foreign keys improve performance?
Which software is used for pl sql programming?
What is a column in a table?
What is the difference between the conventional and direct path loader? : aql loader
what is a stored procedure? : Sql dba
how many values can the set function of mysql take? : Sql dba
what is dbms? : Sql dba
What is sql not null constraint?
Does sap use sql?
How are sql commands classified?
Is the primary key an index?
What is orm in sql?
How can you select unique records from a table?
What are different types of tables in sql?
How do you go back in sql?