Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 11004 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
What structure can you implement for the database to speed up table reads?
How do you identify a foreign key?
What do mean by xml datatype?
What are the three different part of rdl file explain them?
Can foreign key be duplicate?
Can two tables share the same primary key?
What is sql server 2000 work load governor?
What is the advantage of sql server?
How many primary keys are possible in a table?
what are different types of raid configurations? : Sql server database administration
What is factless fact table? : sql server analysis services, ssas
What is PROJECTION Operation?
What is the difference between stored procedure and functions?
How to use user defined functions in expressions?
Is port 1433 secure?
