Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6995 Views
- I also Faced
- E-Mail Answers
Answer Posted / deshabandhu bar
Static query is faster as this keep the Execution plan in
the lib cache. Also it keeps data blocks in the buffer
cache. Next time when a user try to execute the same query
the user hit the cache and execution plan will be ready for
that user. So the time required for parsing and creating
execution plan will be 0. So the Static query is faster
than the dynamic query.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the difference between data migration and production migration.
Explain the use of analyse option in exp command.
What is sequence?
What is Redo Log Buffer in Oracle?
Explain compound trigger in oracle?
Difference between pre-select and pre-query
List out the components of logical database structure of oracle database.
What is the usage of save points in oracle database?
Explain what are the different type of segments?
Can I create users through internet explorer in oracle 10g?
How to use "in out" parameter properly?
How to rename a tablespace in oracle?
How to select all columns of all rows from a table in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to execute the package in oracle?
