Alternative to materialized view

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



Alternative to materialized view



I have a UI which needs to be populated by an underlying database query. This query is quite complicated having several joins between tables and take around 2-3 minute to execute. I tried using materialized view but I want the most recent data ( as base tables are very frequently updated) and materialized view "on commit refresh" will make update/insert on base tables slow which I can not afford. Is there any other way I can do this?




1 Answer
1



Use fast refresh and schedule the mview refresh on frequent interval






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Firebase Auth - with Email and Password - Check user already registered

Dynamically update html content plain JS

How to determine optimal route across keyboard