when to use materialized views
hi ,
need to seek advise on materialized views
i have a job that execute and get data from a view every 15 mins with possible changes to data but not very sure of the extend of the changes as the underlying tables will get either inserted/updated by another process elsewhere that i am not sure of
will a materialized view help in anyway here ?
kindly advise
tks & rdgs