Database DataWarehousing (MOSC)

MOSC Banner

Materialized View on oracle 9i

edited May 9, 2012 12:42AM in Database DataWarehousing (MOSC) 1 commentAnswered
Hi all,

   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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center