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

What are the different editions of oracle?

589

Explain what does a control file contain?

607

What do you mean by group by clause?

555

What is dual table oracle?

525

What is open database communication (odbc) in oracle?

544

Explain the use of record length option in exp command.

554

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1618

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1615

How to count groups returned with the group by clause in oracle?

572

What is the database name in oracle?

532

How to rename a column in an existing table?

615

What do you mean by a tablespace?

560

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1434

What is oracle data type?

553

What is merge statement used for?

563