Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7139 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 |
9. Display the client name and order date for all orders using the JOIN . . . USING method.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to loop through a cursor variable?
Explain the use of control file?
How are extents allocated to a segment?
what is main def between plsql/table and array?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Explain the use of grant option in exp command.
Can we convert a date to char in oracle and if so, what would be the syntax?
What is a cluster Key ?
Give the various exception types.
Oracle General 
