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

Explain table?

849

What are the advantages of oracle?

754

How to select all columns of all rows from a table in oracle?

775

Explain the use of owner option in exp command.

765

Is java required for oracle client?

724

What are the predefined tablespaces in a database?

766

How to return top 5 rows in oracle?

779

Describe the types of sub query?

745

How to count duplicated values in a column in oracle?

774

What is null value in oracle?

830

What is recovery manager(rman) backup in Oracle?

870

How can I see all tables in oracle?

732

How to turn on or off recycle bin for the session?

818

How do I uninstall oracle 11g?

789

How to create a server parameter file?

799