Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to convert csv to table in oracle?
why dont we assign not null constraint as table level constraint.
How index is implemented in oracle database?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to define an oracle sub procedure?
How to use null as conditions in oracle?
How to use subqueries in the from clause in oracle?
How do we get field details of a table?
Explain parameter file in oracle.
What are operators in oracle?
What are the ansi data types supported in oracle?
ABOUT IDENTITY?
What is hot backup and logical backup?
types of indexes and the rationale behind choosing a particular index for a situation.
How to create a new user account in oracle?
