Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7115 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
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How can we view last record added to a table?
How to execute the package in oracle?
Can you have more than one content canvas view attached with a window ?
How to store pictures on to the database?
How to start a specific oracle instance?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is the difference between formal parameters and actual parameters?
Is there a function to split a string in plsql?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to turn on or off recycle bin for the instance?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to use attributes of the implicit cursor in oracle?
How to load data from external tables to regular tables?
Explain the use of constraints option in exp command.
