Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6989 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 are the factors causing the reparsing of SQL statements in SGA?
What is the difference between sharding and replication?
How you find out version of installed workflow?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
What a SELECT FOR UPDATE cursor represent.?
What is data type in oracle?
What is Partitions in Table ?
What are the types of synonyms?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
3. Display all the client numbers in the ORDER table. Remove duplicates.
how will I find the first 5 highest salaried employees in each dept in oracle.
Explain what are the advantages of views?
Oracle General 
