yes. we can. http://msdn.microsoft.com/en-us/library/aa258260 (v=sql.80

Can we create index on views?

Question Posted / prakasam

Answer Posted / prakasam

yes. we can.

http://msdn.microsoft.com/en-us/library/aa258260
(v=sql.80).aspx - Refer the url

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is normalisation?what are its uses?

1941

Explain the use of owner option in exp command.

759

Is oracle a programming language?

744

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

817

How to invoke the original export import utilities?

682

How to login to the server without an instance?

793

How to run create database statement again?

794

Explain the use of tables option in exp command.

812

How are extents allocated to a segment?

771

What is user managed backup in Oracle?

824

What do you mean by a tablespace?

768

What happens to indexes if you drop a table?

907

How to see the table columns used in an index?

773

Can sub procedure/function be called recursively?

737

What is ceil and floor in oracle?

792