oracle - About materialized view and performance enhancement for frequently update base table

Question

In our oracle query, I used materialized view to improve the performance and saw a drastic change in performance time of query, response time is in .17 seconds now rather 30 seconds so its working in case we are working on historical data set and need to have one time refresh of materialized view but now requirement is if base table of materialized view would be updating frequently in that case it would be working as the refresh activity of materialized view would be consuming time as well, currently the base table has around 170000 records but in future definitely going to increase so is there any solution or option to resolve this. As i have tried to apply Indexes as well on the table but not able to achieve response time within .17 sec or around the last response time based on index creation was 18 sec.

标签： oracle