Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: VIEWS compared to Nodes as Windows into data

Re: VIEWS compared to Nodes as Windows into data

From: Alfredo Novoa <alfredo_at_ncs.es>
Date: Thu, 29 Apr 2004 15:24:20 GMT
Message-ID: <40911d8c.18821003@news.wanadoo.es> 





On Thu, 29 Apr 2004 10:07:00 -0400, "Laconic2" <laconic2_at_comcast.net>
wrote:



>What's the disadvantage of snapshots?  The data is less current.




You may have always up to the date snapshots.



>VIEWS can be poor performers for a variety of reasons.  Among them: sloppy

>view design, sloppy index design,  sloppy table design.




The strongest reason is obsolete DBMS design.




Regards


  Alfredo
Received on Thu Apr 29 2004 - 10:24:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US