What is the diff between Dynamic queries and static queries
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
What is local temp table?
Explain how to integrate the ssrs reports in application?
How would you add a section to a table?
What is difference between equi join and inner join?
Can you get second highest salary from the table?
Explain activity monitors
How to find tables without indexes?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the tcp/ip port on which sql server runs?
What is an active database?
What is bcp? When does it used?
What is the difference between delete and truncate statements?
How can I change procedure name in sql server?
What triggers long term care?
What is right outer join in sql server joins?