Materialized View on oracle 9i
I want ask about the Materialized View (MV) in oracle 9.2.0.4. I were read documents about MV and seem as them have been used in Replicate environtment and DataWarehouse. I have a SQL and it includes lot of operations like SUM, AVG, ... and my DB is local (not replicate, DW). Yes, I do not experience about MV. So in this my case, Can I use MV to improve SQL ? Or some advises about MV (ex: tuning it, how it impact to DB) ?
In the MV, if use REFRESH FAST, it's seem as job scheduler in DB. And if, this SQL need process much of data --> So this MV is good ?