- Katılım
- 19 Ocak 2023
- Mesajlar
- 9
- Excel Vers. ve Dili
- I am using Microsoft Excel 2019 in English.
I encountered this question regarding materialized views.
If a user runs a report which is built on top of a materialized view while the materialized view refresh is in progress, the results of the report may not be accurate due to the incomplete refresh.
The on demand refresh method will clear out all existing data and generate new data, so the user may not have any data visible in their report when the refresh is complete.
Will my SELECT statement retrieve data from before the current update, or will it retrieve the newly updated data?
When I execute a SELECT statement, Oracle will retrieve the data from the snapshot it took previously, meaning that the data it returns is the same as what was present before.
Please shares your insights.
If a user runs a report which is built on top of a materialized view while the materialized view refresh is in progress, the results of the report may not be accurate due to the incomplete refresh.
The on demand refresh method will clear out all existing data and generate new data, so the user may not have any data visible in their report when the refresh is complete.
Will my SELECT statement retrieve data from before the current update, or will it retrieve the newly updated data?
When I execute a SELECT statement, Oracle will retrieve the data from the snapshot it took previously, meaning that the data it returns is the same as what was present before.
Please shares your insights.