Answer Posted / ashok naik
Yes that is called indexed views using this we can improve
Query performance if your view contain single select
stament then we can easily establish unique clusterd index
| Is This Answer Correct ? | 63 Yes | 20 No |
Post New Answer View All Answers
What is meant by a deadlock situation?
What is Trigger in Oracle?
Explain implicit cursor.
What is snapshot is too old? Give and example for better understand.
How to find out what oracle odbc drivers are installed?
What is the database name in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Can sub procedure/function be called recursively?
What is the use of aggregate functions in oracle?
what are the advantages of running a database in archive log mode?
How does Oracle guarantee data integrity of data changes?
What are the different types of modules in oracle forms?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain oracle left join with an example?
What is a named program unit?
