Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query rewrite
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?
Matthias Hoys wrote:
> "Ryan S" <rshevchi_at_vt.edu> wrote in message
> news:1121453783.651313.19790_at_g14g2000cwa.googlegroups.com...
> > Yes I did, they are all range scans or unique scans. I would post the
> > plans here if I could.
> >
>
> How about using materialized views ? Is the table data constantly changing
> or rather static ?
>
>
> Matthias
Received on Sat Jul 16 2005 - 12:31:31 CDT