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 happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What are the restrictions on external table columns?
What is a table in oracle?
can u plz provide me oca sql dumps please i need them
What happens to the current transaction if the session is killed?
What is oracle thin client?
How to invoke the original export import utilities?
Describe an oracle table?
How to speed up webrick?
Explain the features of oracle?
What is a system tablespace and when it is created?
What is partitioned table in Oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to run queries on external tables?
Can sub procedure/function be called recursively?