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_at_posting.google.com>
Date: 21 Jan 2003 09:55:59 -0800
Message-ID: <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 Tue Jan 21 2003 - 18:55:59 CET