Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7118 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 |
What is meant by joins? List out the types of joins.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain the blob datatype?
how to genarate random numbers in oracle for particular row?
Can we protect our pl/sql source code?
What is backup in Oracle?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is the difference between normal and corelated subqueries?
What are nested tables?
Explain the use of parfile option in exp command.
How to omit columns with default values in insert statement in oracle?
Oracle General 
