Answer Posted / md sajjad
No We cannot create index on view:
e.g
1* create view emp_view as select * from emp where
deptno=20
SQL> /
View created.
1* create index indx_emp on emp_view(empno)
SQL> /
create index indx_emp on emp_view(empno)
*
ERROR at line 1:
ORA-01702: a view is not appropriate here
| Is This Answer Correct ? | 39 Yes | 16 No |
Post New Answer View All Answers
How to do clean up if create database failed?
What is Data Dictionary Cache in Oracle?
What is data type in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What privilege is needed for a user to create views in oracle?
What is an Oracle index?
How to set a transaction to be read only in oracle?
What are the common oracle dba tasks?
material view and view disadvantages?
How many types of tables are there in oracle?
Define oracle database
How different is ms access and oracle?
Is oracle a language?
What is a cognitive schema?
is there a tool to trace queries, like profiler for sql server?