I have a table (A) with 750+ million records and another one (B) which is a summary of information in A containing 30+million records.
Now I wonder whether it wouldn't be better to have B as an indexed materialized view. Though not often, there will be situations where B has to be updated. In the past I avoided materialized views when the result of a query contains more than about 1 million records. I do not know enough about the implications for the server's resources to make an informed decision though. What are the pro's and con's of large materialized views vs. tables in a case like this? Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
