[SGVLUG] Probably more "dev" related, but a question on databases...

Jeremy Leader jleader at alumni.caltech.edu
Fri Jan 8 15:38:21 PST 2010


Emerson, Tom (*IC) wrote:
> ... doesn't a "view" imply
> extra processing and/or storage to support the view?  [i.e., a "temporary"
> table built and populated with a copy of the data]

My understanding was that in Oracle, a "materialized view" was one that actually 
created a table; normal views were more like canned queries.  I don't know if 
this is the case in all databases, though.

-- 
Jeremy Leader
jleader at alumni.caltech.edu


More information about the SGVLUG mailing list