Can we create index on views?

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

How to define an explicit cursor in oracle?

591


What is dynamic proxy?

541


What is the implicit cursor in oracle?

554


What are the differences between lov and list item?

550


what happened to the global index when I truncate the data in one of the partition?

1511






What are dml statements in oracle?

608


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1548


Explain implicit cursor.

546


What is oracle in java?

515


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1605


what are archived logs?

1704


How to get last row id?

547


How to manage transaction isolation level?

548


What are the different editions of oracle?

582


How to create a stored procedure in oracle?

567