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

Can we create index on views?

Question Posted / janaka

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain a synonym?

1034

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2239

What is oracle sid?

957

How to create a stored procedure in oracle?

1106

What happens to the current transaction if the session is ended?

1100

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2189

Differentiate between function and procedure in oracle.

1086

what are archived logs?

2205

Explain a private synonyms?

1043

What are ddl statements in oracle?

1077

What is the use of oracle?

1030

what is the dual table in oracle?

996

Why does Oracle not permit the use of PCTUSED with indexes?

2426

How to start your 10g xe server?

1045

What is a partition in oracle?

1126