Skip to main content
Open

Enable snapshot (materialized/indexed views) for Mssql

Related products:Software Factory

We wanted to create a snapshot (materialized/indexed view) in the SF to make it easier to display information such as stock aggregations,  but we can't get it to work.

We can see multiple users having problems with this: Snapshot creation SQL SERVER | Thinkwise Community

 

It seems this is not yet enabled for Mssql. Can this be realized?

What are 'Snapshot' views and how to use them? | Thinkwise Community

Did this topic help you find an answer to your question?

3 replies

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
NewOpen

AndreKemmeren
Captain
Forum|alt.badge.img+3

The docs don't mention that this isn't supported for MSSQL so we wasted a good amount of time trying to get it working until we stumbled upon the topics on the community.

 

Having Indexed Views could speed up important parts of applications so I hope this was simply forgotten and will be added as a high priority item on backlog ;)


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi ​@AndreKemmeren,

Although I am not the person to make a judgment on the priority of this idea, I can create a ticket for our Documentation team to clarify the current state. Thank you for bringing this to our attention, and apologies for the time this cost you.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings