Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7247 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 the difference between first normal form & second normal form?
What is the fastest query method to fetch data from the table?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What are temporal data types in oracle?
Explain what are the different type of segments?
What is the exact use of Collections?
What is an oracle user role?
How to get the Installed Oracle Version Information ?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What is rowid and rownum in oracle?
what r tyhe major differences between oracle 9i & 10g?
Can you assign multiple query result rows to a variable?
Oracle General 
