Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10902 Views
- CGG, ICS Integrated Computer Solutions, I also Faced
- E-Mail Answers
Answer / 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 |
What do you understand by check constraint in sql server?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
What are the ways available in sql server to execute sql statements?
What are date and time data types in ms sql server?
What is default constraint in ms sql server?
Tell me can we use custom code in ssrs?
Write a program to fetch first 10 records from a file?
What is difference between count (*) and count column?
What information is maintained within the msdb database?
What are the different type of replication in sql server?
What are different types of join?
what is extended StoreProcedure ?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
