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 are the original export and import utilities?
What is the sid in oracle?
What are the execution control statements?
what happened to the global index when I truncate the data in one of the partition?
What is ADDM Advisor in Oracle?
How to rename an existing table?
Can we insert data in view oracle?
How to convert characters to times in oracle?
Explain the difference between replace() and translate() functions in oracle?
How do we get field details of a table?
What is sequence?
How do I find the database name in oracle?
What is the difference between online and offline backups?
How do I spool in oracle?
What are the parameters that we can pass through a stored procedure?