Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10901 Views
- CGG, ICS Integrated Computer Solutions, I also Faced
- E-Mail Answers
Answer Posted / jerry joseph
Static query will be executed as it is.
Dynamic query is built upon conditions depending upon the
parameters.
Static query will create an execution plan during compilation.
Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
how to overcome kernel isssues
What is global temp table?
Explain the difference between HTTP and HTTPS in database?
How can we delete Duplicate row in table?
what is create database syntax? : Sql server database administration
Why should we go for stored procedures? Why not direct queries?
What is raid? : SQL Server Architecture
What is ms sql server triggers?
How to insert and update data into a table with "insert" and "update" statements?
Which is the latest version of sql server and when it is released?
How to override dml statements with triggers?
explain declarative management framework (dmf) in sql server 2008?
How check triggers in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is a transaction and why is it important?
