Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6550 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
List the various oracle database objects?
What is Segment Advisor in Oracle?
How to load data from external tables to regular tables?
What is pragma autonomous transaction in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
How does Oracle guarantee data integrity of data changes?
How to sort the query output in oracle?
How to drop a tablespace?
What is Trigger in Oracle?
What is Java Pool in Oracle?
Explain compound trigger in oracle?
What are the different types of partitions in oracle?
Oracle
Explain oracle left join with an example?
Can we insert data in view oracle?
