Path: utzoo!attcan!uunet!zaphod.mps.ohio-state.edu!ub!uhura.cc.rochester.edu!rochester!pt.cs.cmu.edu!o.gp.cs.cmu.edu!andrew.cmu.edu!bg0l+ From: bg0l+@andrew.cmu.edu (Bruce E. Golightly) Newsgroups: comp.databases Subject: Re: Views make base table updates more slowly in INGRES? Message-ID: Date: 26 Oct 90 20:36:16 GMT References: <1697@kielo.uta.fi> Organization: Carnegie Mellon, Pittsburgh, PA Lines: 10 In-Reply-To: <1697@kielo.uta.fi> That might be true, depending on what makes up the view and what objects are associated with the base table(s). A complex view consisting of a number of tables linked together might take a while to update. This could be complicated by base tables with inappropriate structures or lots of secondary indices.I suspect, though, that there is no appreciable difference between operating on a view and performing the same set of operations on the corresponding set of tables. How about more details?