Can views be indexed? If yes, which views can be indexed and can index be altered?

  • Interview Candidate
  • 2
  • 3261

Showing Answers 1 - 2 of 2 Answers

Harsh Gupta

  • Apr 8th, 2006
 

Hi

1) Sql Server 2000 and Oracle does have added the facility of indexed views. Prior to Sql Server 2000 indexed views were not there.

2) Oracle call them as Materialized views and Sql Server 2000 call them as Indexed views

3) I think all the views can be indexed and index too can be altered but i am not sure on this.

Regards

Harsh Gupta

  Was this answer useful?  Yes

John

  • Jun 8th, 2006
 

There are restrictions on indexed views in SQL server such as the columns are not nullable.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions