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 are the numeric comparison operations?
Explain what are the different type of segments?
What happens if you set the sga too low in oracle?
How to use "for" statements in oracle?
How to check the oracle tns settings?
What are the predefined tablespaces in a database?
How to use in conditions in oracle?
what is the use of system.effective.date variable in oracle?
How to omit columns with default values in insert statement in oracle?
How to list all indexes in your schema?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to convert times to characters in oracle?
Explain what are the advantages of views?
In oracle there is column command, how will you explain that?
What is partitioned table in Oracle?
