Good morning guys - I want to know about materialized view

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
david ribeiro guilherme
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Tue, 11 Jan 2005 7:44 am
Location: Catanduva - SP
David Ribeiro Guilherme
Programador
ribeiro131@hotmail.com

Could someone explain to me what a materialized view is and what is it? , another question Question materialized is the same as Snapshot?
User avatar
dr_gori
Moderador
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

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.
User avatar
MuLtAnI
Moderador
Moderador
Posts: 90
Joined: Tue, 01 Jun 2004 9:21 am
Location: Videira - SC
Contact:

So the name of Snapshot, which means something like quick viewing of data ...


[]
Post Reply
  • Information
  • Who is online

    Users browsing this forum: Google [Bot] and 18 guests