Please explan Why static query is more faster than dynamic
query ?
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
What are the execution control statements?
Briefly explain what is literal? Give an example where it can be used?
Explain the use of show option in imp command.
List the types of joins used in writing subqueries?
what is the difference between substr and instr function in oracle?
query optmization techniques and quwry analyser+projects+ppts
What exactly do quotation marks around the table name do?
How to resolve name conflicts between variables and columns?
How do we display rows from the table without duplicates?
Explain the importance of .pll extension in oracle?
In which language oracle has been developed?
How a database is related to tablespaces?
Explain implicit cursor.
How to start your 10g xe server from command line?
How to use windows user to connect to the server?