Re: Materialized View to Subset Data, Is This Possible
From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 21 Jan 2003 21:54:31 -0800
Message-ID: <130ba93a.0301212154.ceeb7d4_at_posting.google.com>
Date: 21 Jan 2003 21:54:31 -0800
Message-ID: <130ba93a.0301212154.ceeb7d4_at_posting.google.com>
- Jusung Yang
nick_wakefield_at_hotmail.com (Niko) wrote in message news:<9da94cd1.0301210955.343e7747_at_posting.google.com>...
> Materialized Views to Subset Data
>
> Is it possible to create a materialized view to pre-subset the data
> and query rewrite to use this.
>
> e.g
> CREATE MATERIALIZED VIEW MV_TEST
> REFRESH FAST ON COMMIT
> ENABLE QUERY REWRITE
> AS
> select * from sales where region = 'WEST'
>
> Then if I run the following query
>
> select * from sales where region = 'WEST' and PRODUCT = 'TIRES'
>
> The materilized view will use the subset.
>
> If not is this possible in 9i.
Received on Wed Jan 22 2003 - 06:54:31 CET