Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7134 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
What are the different types of failures that occur in Oracle database?
What is background process in Oracle?
What is the difference between PFILE and SPFILE in Oracle?
How many memory layers are in the oracle shared pool?
Is rowid unique in oracle?
How to list all tables in your schema?
How to download oracle database 10g xe?
Explain what are the type of synonyms?
Explain the use of owner option in exp command.
Explain about the analyze command in oracle?
How can we view last record added to a table?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is an oracle and why it is used?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to call a stored function in oracle?
