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

Give the different types of rollback segments.

977

Give the constructs of a package, function or a procedure.

979

How to check database size in Oracle?

1106

Differentiate between post-database commit and post-form commit?

978

How to divide query output into groups in oracle?

942

What are the limitations oracle database 10g xe?

974

What is ceil and floor in oracle?

1005

How to save query output to a local file?

967

What is data block in Oracle?

1042

What is the best way to do multi-row insert in oracle?

1012

How to get execution statistics reports on query statements?

1004

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1982

How to view all columns in an existing table?

869

Name the three major set of files on disk that compose a database in Oracle?

1061

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

1007