Answer Posted / itishree chhotray
View should be Schema binding,before creating index on view.
We can create Unique Clustered index on view after that we
can create non clustered index but we should have at least
one unique clustered index on view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to start a new transaction in oracle?
How to retrieve data from an cursor to a record?
What is a subquery in oracle?
How to create a new oracle data file?
What is the usage of control file in oracle?
various types of hints and their usage
What is translate in oracle?
Can we save images in a database and if yes, how?
What is a nvl function?
What is set verify off in oracle?
What is primefaces used for?
State and explain about oracle instance?
What is oracle analytical function?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
