Good morning Folks-I want to know about view Materialized

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Wed, 09 Feb 2005 9:29 am

Could someone explain to me what is a materialized view and what is it for? , another question view materialized is the same as snapshot?
david ribeiro guilherme
Location: Catanduva - SP

David Ribeiro Guilherme

Poston Wed, 09 Feb 2005 3:10 pm

View materialized is like a table that is created on the basis of a SQL statement. Is the same as a snapshot.

Serves for cases where it's not worth running a view normal (because of performance, for example), then the data are recorded in a table. The query passes be real quick.

Is used for cases where the data does not change much.
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Poston Tue, 15 Feb 2005 5:00 pm

Hence the name of Snapshot, which means something like fast data visualization ...

[] 's
Location: Videira - SC

  • See also
    Last Post

      Return to SQL

      Who is online

      Users browsing this forum: Bing [Bot] and 6 guests