Can we create index on views?

Answer Posted / murali krishnan

yes we can create index on views

Is This Answer Correct ?    25 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert dates to characters in oracle?

773


Why do we use coalesce function in oracle?

855


Is oracle a programming language?

752


does the query needs a hint to access a materialized view?

1652


Explain the difference between replace() and translate() functions in oracle?

799


What are the differences between primary key and unique key?

728


How different is ms access and oracle?

769


candidate key is subset of super key but not vice-verse explain

1788


Hi Can any one tell me what are the API's used in requisition import.

1704


What to do if dba lost the system password?

832


How to use fetch statement in a loop?

774


Explain rename?

735


How to use null as conditions in oracle?

763


How to count duplicated values in a column in oracle?

778


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

781