no we cann't create an index on a view.why because view is a virtual

Can we create index on views?

Question Posted / siva

19 Answers
125162 Views
CTS, Syntel, TCS, I also Faced
E-Mail Answers

Answer Posted / siva

no we cann't create an index on a view.why because view is
a virtual table.when u select the view it will get the data
from base(database)table.
view is a stored query.so we cann't

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

defination of bitmap index

2044

How to rename an existing table?

1049

What is a cursor variable?

1044

How to return top 5 rows in oracle?

986

How to execute a stored program unit?

1004

What is BBED in Oracle?

1089

What is connection pool in oracle?

926

What is transport network substrate (tns) in oracle?

991

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4471

What is private procedure oracle?

953

Explain alias?

1078

Can objects of the same schema reside in different tablespace?

1000

What is a nested table?

1004

Explain the use of Merge statement in oracle 11g

975

Difference between hot backup vs. Cold backup?

945