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 a user role in oracle?
What operating systems are supported by oracle database 10g xe?
What privilege is needed for a user to query tables in another schema?
What is a table in oracle?
What are the different types of failures that occur in Oracle database?
What is oracle data type?
How to commit the current transaction in oracle?
What do you understand by a database object?
Explain the use of indexes option in exp command.
What are nested tables?
How many types of cluster table in Oracle?
What is procedure overloading in oracle?
How to change user password in oracle?
what is reindexing?
How do I spool in oracle?