Interested to Buy Any Domain ? << Click Here >> for more details...
Please explan Why static query is more faster than dynamic
query ?
- 2 Answers
- 6988 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What suggestions do you have to reduce the network traffic?
Can we write dml statement in function in oracle?
Explain enable novalidate constraint.
How to update a table row with a record?
What is a table index?
What are temporal data types in oracle?
Please explain oracle left join with an example?
does the query needs a hint to access a materialized view?
What is the usage of control file in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
what is the scenario where you take the database to NoArchivelog mode?
What is tns service name?
What is the difference between view and materialized view in Oracle?
what are archived logs?
How to view the data files in the current database?
