GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database

 Print  |  
Question:  Can views be indexed? If yes, which views can be indexed and can index be altered?



April 04, 2006 02:02:49 #1
 Harsh Gupta   Member Since: Visitor    Total Comments: N/A 
RE: Can views be indexed? If yes, which views can be i...
 

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
     

 

Back To Question