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