Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6548 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 view the data files in the current database?
What is a system tablespace and when it is created?
State the various uses of dbcc command?
How can we find out the duplicate values in an oracle table?
How remove data files before opening a database?
How to pass parameters to procedures in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is a database table in oracle?
What is logical backup in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the sid in oracle?
Explain the use of owner option in exp command.
How to connect to oracle using service name instead of sid?
what is the dual table in oracle?
What are the differences between char and varchar2 in oracle?
