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!
Solved
What are 'Snapshot' views and how to use them?
+23Best answer by Jasper
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 originalFor 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 😉.
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 😉.
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 😉.
+23Thanks Jasper for explaining! We will discuss the need of Snapshots in our project and submit an Idea if we want to use it.
"Wake me up before you low-code"
1 person likes this
- Vanguard
Hi
Any updates on this topic? We would like to use snapshots to improve performance as some calculated columns / views take long to load. However, we cannot find much information on this topic in the documentation.
Thanks!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.