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