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
List out the difference between commit, rollback, and savepoint?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
what is port in oracle? how is it related to database application.
How is it different from a normal table?
How to connect ms access to oracle servers?
How to rename an existing table?
What is Undo Management Advisor in Oracle?
List out the types of joins.
How to experiment a data lock in oracle?
How to create a new view in oracle?
List the various oracle database objects?
How many types of segments in Oracle?
What is an external table?
Can we create trigger on materialized view in oracle?
Difference between open_form and call_form in oracle.