Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6996 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 |
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How many file formats are supported to export data?
What are the ways tablespaces can be managed and how do they differ?
How to run the anonymous block again?
What are the data types in oracle?
How to use select statement to count the number of rows in oracle?
Explain the use of record option in exp command.
What are the components of logical database structure in oracle database?
How to select the name of employee who is getting maximum sal with out using subquery
write a query that displays every Friday in a year with date?
What is Reduced List of Values?
Oracle General 
