Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10803 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 happens if date-only values are provided as date and time literals?
What is the Difference Between Primary and Foreign Key?
Where are full-text indexes stored?
What are the properties of primary key?
What are .mdf files?
how many type of indexing in database?
What is full outer join in sql server joins?
What are different types of collation sensitivity?
How to skip remaining statements in a loop block using continue statements?
What are the purposes of floor and sign functions?
How to delete a login name in ms sql server?
What is the web service used for reporting services?
Can we hide the definition of a stored procedure from a use?
What are the different SQL Server Versions you have worked on?
what are the disadvantages of cursors? : Sql server database administration
