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 r tyhe major differences between oracle 9i & 10g?
What is a partition in oracle?
Display the number value in Words?
25. Display the client number and the value of the highest value order placed by that client.
How do I recompile a procedure in oracle?
What are the different type of Segments ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do we create privileges in oracle?
Can you use a commit statement within a database trigger?
What is difference between truncate and delete?
When does a Transaction end ?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?