Please explan Why static query is more faster than dynamic
query ?

Answers were Sorted based on User's Feedback



Please explan Why static query is more faster than dynamic query ?..

Answer / 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

Please explan Why static query is more faster than dynamic query ?..

Answer / 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

More Oracle General Interview Questions

what r tyhe major differences between oracle 9i & 10g?

6 Answers  


What is a partition in oracle?

0 Answers  


Display the number value in Words?

1 Answers  


25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,


How do I recompile a procedure in oracle?

0 Answers  


What are the different type of Segments ?

2 Answers  


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


How do we create privileges in oracle?

0 Answers  


Can you use a commit statement within a database trigger?

4 Answers  


What is difference between truncate and delete?

0 Answers  


When does a Transaction end ?

2 Answers  


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)