Materialized view r useful in data wearhousing.
It's useful in queries with joins,aggregates functions.
if single table queries with aggregate function then u can use mview for that. That is called single table mview. which can improve responce time of query and also reduce i/o contention on that table.
kuckoo