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  >  Data Warehousing  >  Basics

 Print  |  
Question:  What is the difference between view and materialized view



July 07, 2006 04:59:17 #3
 Minal   Member Since: Visitor    Total Comments: N/A 

RE: What is the difference between view and materializ...
 

Normal Views are for Access purpose ie One need to give access the end user to specific data.

Materialized Views are to optimize the performance . WHen materialzied view are used in the queries ,stored results are fetched (Instead of fecthing from individual talbes) which improves the performance. Refreshing option for materialised view can be set.

     

 

Back To Question