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 -> Materialized View to Subset Data, Is This Possible

Materialized View to Subset Data, Is This Possible

From: Niko <nick_wakefield_at_hotmail.com>
Date: 21 Jan 2003 09:55:59 -0800
Message-ID: <9da94cd1.0301210955.343e7747@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 Tue Jan 21 2003 - 11:55:59 CST

Original text of this message

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