Answer Posted / mahesh kumar
we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a partition in oracle?
What is a procedure in oracle?
How to put more than 1000 values into an oracle in clause?
Explain drop constraint oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to define an anonymous procedure without variables?
Explain oracle data types with examples?
How remove data files before opening a database?
What are the varoius components of physical database structure of oracle database?
What is meant by raw datatype?
Explain do view contain data?
List out the components of logical database structure of oracle database.
What is rich query?
types of indexes and the rationale behind choosing a particular index for a situation.
Is oracle a relational database?