Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7242 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
master table and child table performances and comparisons in Oracle ?
How do you find current date and time in oracle?
Name the three major set of files on disk that compose a database in Oracle?
How to write a left outer join with the where clause in oracle?
interview questions with answer for cts
How index is implemented in oracle database?
What is oracle rownum?
How to create a temporary table in oracle?
What is rich query?
Explain what are the type of synonyms?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is a nested table and how is it different from a normal table?
Explain cascading triggers.
What is integrity and what is constraint??Explain with example
What is an oracle table?
