Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7012 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to concatenate two text values in oracle?
Difference between varchar and varchar2 data types?
How do we get field detail of a table?
How to get execution statistics reports on query statements?
Where are the settings stored for each instance in oracle?
What is the parameter mode that can be passed to a procedure?
Write a syntax for update query in oracle?
What privilege is needed for a user to connect to oracle server?
What is connection pool in oracle?
how the indexes are stored in the Oracle Database?
Explain table?
What is oracle rownum?
How can you merge two tables in oracle?
Explain the use of inctype option in exp command.
please explain.. DB architecture ...
