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

Can we create index on views?

Question Posted / prakasam

19 Answers
125909 Views
CTS, Syntel, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the relation of a user account and a schema?

1134

How to run queries on external tables?

1046

What is the use of file param in imp command?

1165

What is snapshot is too old? Give and example for better understand.

1603

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2273

How to change user password in oracle?

1029

How can you merge two tables in oracle?

1001

How to assign values to data fields in record variables?

1035

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

1020

What is a server parameter file in oracle?

1058

What is the difference between view and materialized view in Oracle?

1154

How remove data files before opening a database?

1072

How to convert csv to table in oracle?

990

How to convert raw data type into text in oracle? Explain

993

What is Java Pool in Oracle?

1169