3 ms·Yes, in these situations materialized views with indexes are generally the correct answer.by cgh 5y agoYes, in these situations materialized views with indexes are generally the correct answer.