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

How do I find my oracle client driver version?

982

Explain the use of record option in exp command.

952

What are the varoius components of physical database structure of oracle database?

952

What the is the diff between local index and global index. give some example.

1593

What is sequence?

1017

Explain the types of exception?

1086

How to rename an index in oracle?

1070

List out the components of logical database structure of oracle database.

995

How to use select statement to count the number of rows in oracle?

997

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1049

How to define and use table alias names in oracle?

888

How to retrieve data from an explicit cursor?

1013

Is oracle an operator?

890

What is an oracle function?

1086

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943