Have a bit of glitches from the time I was using SQL Server back in 2006 and the many other databases I played with (and which I have not touched since then).
I need to create a materialized view to quickly get access to the data without overloading the DB but also to pull them what it was made static by the time the view was created.
SQL Server seems to support the materialized views with the Indexed views, but to be created these require among the other thing the following:
- the WITH SCHEMABINDING construct
- a clustered INDEX
Failing in that, my understanding is the view is not auto refreshing, which is probably what I need?
My goal is to get a view, that I can refresh whenever I need.
So far I created a Materialized view in the SQL 2005 instance I have access to with the following statement:
CREATE MATERIALIZED VIEW xys AS SELECT 123 FROM X WHERE ... GROUP BY
Any memory refresher?