Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7009 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
Does oracle partitioning improve performance?
How to create an initialization parameter file?
What are the advantages of oracle 12c?
How to use select statement to count the number of rows in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How to use an explicit cursor without open statements?
How to load data from external tables to regular tables?
Explain about integrity constraint?
What are the limitations of check constraint?
What is difference between cartesian join and cross join?
What is a read write transaction in oracle?
What is an oracle user role?
How can windows applications connect to oracle servers?
Explain the use of ignore option in imp command.
How to change user password in oracle?
