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 to omit columns with default values in insert statement in oracle?

571

How to delete an existing row from a table in oracle?

637

How to write text literals in oracle?

602

How to empty your oracle recycle bin?

561

How to turn on or off recycle bin for the session?

602

How to get execution path reports on query statements?

552

query optmization techniques and quwry analyser+projects+ppts

1915

What is a cognitive schema?

522

What is a dead lock in oracle?

583

How to filter out duplications in the returning rows using oracle?

633

What happens if recursive calls get out of control?

539

What are the oracle built-in data types?

555

what is the difference between functional dependecy and multilevel dependency?

1983

How can we find out the duplicate values in an oracle table?

600

How to view all columns in an existing table?

543