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 do you mean by redo log file mirroring?
Explain joins in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is a lookup table in oracle?
List the parts of a database trigger.
How to create tables for odbc connection testing?
How to generate query output in html format?
What is background process in Oracle?
What does sharding mean?
 What are the oracle DML commands possible through an update strategy?
What is a select query statement in oracle?
How to rename a column in an existing table?
What is the usage of merge statement?
Explain the use of indexes option in imp command.
what is a Nested Loop join?
