Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 7109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
How to delete all rows a table in oracle?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is an oracle cursor variable?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to invoke the data pump export utility?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
How to use "out" parameter properly?
what is the use of system.effective.date variable in oracle?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
Explain an extent?
What is the difference between sharding and replication?
Explain mutating triggers.
Oracle General 
