Are the materialized views only useful to decrease the response time of a query where joins are involved?
Dont they help in increasing the performance, even when query runs on a single table by reducing the I/O contention?
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.