Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
syscents
Starting Member
4 Posts |
 Posted - 2009-11-28 : 08:57:23
|
| I want to create an indexed view because I have a complex query that spend some seconds. But I have an issue. I don't want to update data when some row is inserted. No. I want to force the refresh of the indexed view when I want (the same behaviour than materialized views in Oracle).Does somebody know if it's possible? What's the solution?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-28 : 13:33:41
|
| can i ask need of refreshing? will condition inside view change? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
syscents
Starting Member
4 Posts |
Posted - 2009-11-28 : 20:37:23
|
| That's because I have a Window update at night and I don't want that every insert force the refresh of the view. That's because I think every insert-update would spend a few seconds because there is some joins in the sql query. I don't know if the optimizer would calculate only that row or would generate all the view again...Do you know? |
|
|
|
|
|
|
Refresh Index views on demand