I have a table which is based on several base tables. The query for this table is complex and I can’t execute this query in each call. Also, the table needs to have have “created by, created date” etc. columns, so the row in the table needs to remain unchanged if it is not changed in base tables.
Materialized view might be helpful in the situation but am searching if a solution is possible other than that, eg. if I can have some refresh logic and a cron job to refresh the table everyday.