Have Geek Brain

On-demand refresh mode for indexed view (= materialized views) on SQL Server?

I know Oracle offers several update options for its materialized views (on demand, on commit, periodically). Does Microsoft SQLServer support the same functionality for its indexed views?

If not, how can I use indexed views on SQLServer if my goal is to export data to daily + on demand and want to avoid overhead issues? Is there a workaround?

+2


a source to share


1 answer


A materialized view in SQL Server is always up to date, with the INSERT / UPDATE / DELETE overhead that affects the view.



I'm not really sure about your requirements, you didn't quite understand the question for me. However, if you only want the overhead once, on a daily+ on-demand basis

I suggest you drop the index when you don't need it and recreate it when you do. The index will be created when it is created and it will be updated. When the index is dropped, there will be no overhead on your INSERT / UPDATE / DELETE commands.

+2


a source






More articles:


All Articles