Interested to Buy Any Domain ? << Click Here >> for more details...
I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6998 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / john
simple query s best as we can issue query by giving various
condition and it will not get stored in database where as a
procedure will get stored in database and gotta occupy
memory.so its waste of memory and time to create a
procedure rather than issuing a si9ngle query
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which is better cte or subquery?
What is a composite primary key?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to handle bulk data?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is cte?
Are subqueries better than joins?
Explain the difference between sql and mysql.
Is mariadb a nosql database?
What is the difference between Union and Union all. Which is faster.
How do I find duplicates in two columns?
explain about mysql and its features. : Sql dba
Can we use commit inside a trigger?
How many clustered indexes can be created on a table?
Does a primary key have to be a number?
