Yes we can create Indexed view. use CREATE UNIQUE CLUSTERED INDEX i

Can we create index on views?

Question Posted / janaka

Answer Posted / janaka

Yes we can create Indexed view.
use
CREATE UNIQUE CLUSTERED INDEX i_IndexA

ON View_Name(field1,field2)

Is This Answer Correct ?

55 Yes

35 No

Please Help Members By Posting Answers For Below Questions

What is a system tablespace and when it is created?

966

What are advantages of dateset in datastage?

2257

How to write a query with an inner join in oracle?

1031

How to view the tablespaces in the current database?

969

how the indexes are stored in the Oracle Database?

2267

How different is ms access and oracle?

1030

Explain what are the characteristics of data files?

1077

Is oracle the best database?

958

How to establish administrator authentication to the server?

1030

What are the attributes of cursor?

1044

How to use subqueries with the exists operator in oracle?

1017

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2278

What are the database administrators utilities available?

1020

What is a sub query? What are its various types?

1162

Does facebook use oracle?

1027