Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10814 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 are the two virtual tables SQL Server maintains for triggers?
what is Covering Index ?
How to select an exiting database using mssql_select_db()?
what is the maximum size of a row in sql server 2000 and 2005
What is truncate table?
Why we need sql server?
What is shared lock?
How to create function without parameter in sql server?
How to create database with physical files specified in ms sql server?
How do I perform an unattended install of sql server 2000?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are the extra roles available in msdb? : sql server security
-
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)
