Materialized View to Subset Data, Is This Possible

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