Could someone explain to me what a materialized view is and what is it? , another question Question materialized is the same as Snapshot?
Good morning guys - I want to know about materialized view
-
- Rank: Estagiário Pleno
- Posts: 7
- Joined: Tue, 11 Jan 2005 7:44 am
- Location: Catanduva - SP
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
View materialized is like a table that is created based on a SQL. It's the same as a snapshot.
Serves for cases where it is not worth running a normal view (because of performance, for example) ... hence the data is recorded on a table. The consultation becomes very fast.
is used for cases where data does not change much.
Serves for cases where it is not worth running a normal view (because of performance, for example) ... hence the data is recorded on a table. The consultation becomes very fast.
is used for cases where data does not change much.
So the name of Snapshot, which means something like quick viewing of data ...
[]
[]
-
- Information
-
Who is online
Users browsing this forum: Google [Bot] and 18 guests