We can create indexes on materialised views

Can we create index on views?

Question Posted / deepak

Answer Posted / deepak

Is This Answer Correct ?

48 Yes

7 No

Please Help Members By Posting Answers For Below Questions

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2336

Explain an integrity constrains?

1139

Can select statements be used on views in oracle?

1022

What is BBED in Oracle?

1149

How to delete a user account in oracle?

962

Is truncate autocommit in oracle?

1077

In which language oracle has been developed?

1070

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1072

How to write a left outer join with the where clause in oracle?

1082

what is the scenario where you take the database to NoArchivelog mode?

2323

What is set verify off in oracle?

1096

Explain overloading. Can functions be overloaded?

978

What is a package ? What are the advantages of package ?

1085

What is a synonym? What are its various types?

1106

Explain the use of grant option in exp command.

1060