Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6985 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please explain joins in oracle?
How to filter out duplications in the returning rows using oracle?
How to create a new view in oracle?
How to estimate disk space needed for an export job?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain the use of control file?
Why do we use bulk collect in oracle?
What is a nested table and how is it different from a normal table?
What privilege is needed for a user to connect to oracle server?
How to recover a dropped table in oracle?
What is memory advisor in Oracle?
How does Oracle guarantee data integrity of data changes?
What is the difference between 10g OEM and 11g OEM?
How many types of tables are there in oracle?
How to view all columns in an existing table?
