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



June 06, 2006 20:04:56 #1
 zskhan Database Expert  Member Since: June 2006    Total Comments: 3 

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

view - store the SQL statement in the database and let you use it as a table. Everytime you access the view,  the SQL statement executes.

materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Pros include quick query results.

Zafar

     

 

Back To Question