Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7131 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
How to create an oracle database manually?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can we insert data in view oracle?
Differentiate between function and procedure in oracle.
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to assign data of the deleted row to variables?
List the types of joins used in writing subqueries?
How remove data files before opening a database?
How to use in conditions in oracle?
How to drop an existing view in oracle?
What to do if the startbd.bat failed to start the xe instance?
How to handle a single quote in oracle sql?
How to find the duplicate rows count from employees table in oracle?
How can we find out the current date and time in oracle?
Explain the use of online redo log files in oracle.
