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

Home -> Community -> Usenet -> c.d.o.server -> Re: Query rewrite

Re: Query rewrite

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 16 Jul 2005 20:10:47 +0200
Message-ID: <jbjid1p39mjg0p9naccuqjhb6ra0din720@4ax.com>


On 16 Jul 2005 10:31:31 -0700, "Ryan S" <rshevchi_at_vt.edu> wrote:

>There aren't too many updates throughout the day but the customer
>always wants to see the most recent information. What would a
>materialized view buy me here, i'm not that familiar with them?

They would provide you with an *aggregated* copy of the data. As humans appear to read from bottom to top, could you please stop topposting?

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Jul 16 2005 - 13:10:47 CDT

Original text of this message

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