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 do you mean by merge in oracle?
How to start instance with a minimal initialization parameter file?
What is a proxy object?
What is a cursor in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to create a testing table in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
what is a Nested Loop join?
How do I start tns listener?
Explain about the analyze command in oracle?
What is raw datatype?
How to convert dates to characters in oracle?
What is the maximum number of triggers that can be applied to a single table?
What is oracle join syntax?