Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7239 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 work with data objects interactively?
How to get last row id?
What is pragma autonomous transaction in oracle?
What is user managed backup in Oracle?
What is background process in Oracle?
How to delete a user account in oracle?
How to define a variable to match a table column data type?
What are joins, explain all types of joins?
Why cursor variables are easier to use than cursors?
What is data block in Oracle?
How to connect to oracle using service name instead of sid?
How to manage transaction isolation level?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are the oracle built-in data types?
What is the difference between sharding and partitioning?
