Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6128 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uma
In dynamic SQL the SQL statement is prepared each time
before the Run time.But this not the case with static SQL
it ll be stored in shared SQL area and this will refered if
same Query is used again.So static ll be faster
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
How to execute the package in oracle?
Write a syntax for update query in oracle?
What is oracle sid?
What is Database Buffers ?
difference between imlicit cursor and explicit cursor ?
Is rowid unique in oracle?
In Oracle 10g, "g" Stands for what?
What is a static data dictionary in oracle?
Is it possible to enter only time value into a column of a table in sql?
What is rowid and rownum in oracle?
What is a trigger oracle?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Oracle General 
