Solved

What are 'Snapshot' views and how to use them?

  • 16 July 2019
  • 2 replies
  • 66 views

Userlevel 6
Badge +11
As developer we are given some data model table types, namely making a Table, a View or a Snapshot. In the documentation it only says "In a snapshot, just as in a view, data from one or more tables can be combined, though in a snapshot this data is actually saved."

I am unsure how to use it and do not really have the time to experiment with it. Is there someone that can show me what a Snapshot is, what it does, how to set it up (in depth preferably) and what advantages (and maybe disadvantages) it has?

Thanks in advance!
icon

Best answer by Jasper 17 July 2019, 10:35

Snapshots are views whose results are physically stored in a table to improve performance. On DB2 these are called Materialized Query Tables, on Oracle Materialized Views and on SQL Server Indexed Views.

For Oracle and DB2 we have been supporting snapshots for quite some time, but for SQL Server we haven't come to develop it yet.

If you think you need this for SQL Server projects, please read through the limitations and requirements first. And if you still want it, feel free to submit an idea 😉.
View original

2 replies

Userlevel 6
Badge +6
Snapshots are views whose results are physically stored in a table to improve performance. On DB2 these are called Materialized Query Tables, on Oracle Materialized Views and on SQL Server Indexed Views.

For Oracle and DB2 we have been supporting snapshots for quite some time, but for SQL Server we haven't come to develop it yet.

If you think you need this for SQL Server projects, please read through the limitations and requirements first. And if you still want it, feel free to submit an idea 😉.
Userlevel 6
Badge +11
Thanks Jasper for explaining! We will discuss the need of Snapshots in our project and submit an Idea if we want to use it.

Reply