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  >  Informatica

 Print  |  
Question:  what are the difference between view and materialized view?



October 10, 2005 06:29:37 #7
 manjunath   Member Since: Visitor    Total Comments: N/A 

RE: what are the difference between view and materiali...
 

view- the select query is stored in the db. whenever u use select from view, the stored query is executed. Effectively u r calling the stored query. In case u want use the query repetadly or complex queries, we store the queries in Db using View.

where as materialized view stores the data as well. like table. here storage parameters are required.

     

 

Back To Question