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 |
How to find out what privileges a user currently has in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is the difference between formal parameters and actual parameters?
How to resolve name conflicts between variables and columns?
How many memory layers are in the oracle shared pool?
How to select some rows from a table in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
What is a tns file?
Explain what are the different type of segments?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What are the different oracle database objects?
What are various constraints used in SQL?