Please explan Why static query is more faster than dynamic
query ?
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 |
what is index?
What are the restrictions in a oracle read only transaction?
Is a rollback possible to any savepoint?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
How to pass parameters to procedures?
What is not equal to in oracle?
what is difference between foreign key and reference key
what is the difference between no rows returned and null returned?
What is the difference between Sleep and Wait? (Java)
How to store only time; not date and time?
Explain compound trigger in oracle?