2011년 12월 26일 월요일 오후 5:45Are there plans to support Indexed Views in federated databases in the future?
2011년 12월 27일 화요일 오전 2:04중재자
Currently, indexed views are not supported in SQL Azure federation. I would suggest you submit a feedback about it on the Connect site:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.
- 답변으로 표시됨 BrianMcKinley 2011년 12월 27일 화요일 오전 4:12
2012년 4월 30일 월요일 오후 5:07Can anyone explain why indexed views cannot work with federations??
2012년 6월 11일 월요일 오전 3:45
I would imagine this is because the overhead in working out when to recompute indexes on the views would be considerable and complicated (it already is just with normal databases).
It's a terrible pity because I'd love to use SQL Azure for data warehouse storage and take advantage of ROLAP aggregations (which are indexed views). Federation is a perfect fit for us being able to scale out our data too - too bad eh.
2012년 6월 12일 화요일 오전 12:42
I'd prefer it to error if it couldn't (easily) work out how and when to recompute indexed views.
I plan to use compound keys so it would be rather simple to calculate the indexed views (as they still all be local to the federation).
Rather annoying and it means that I won't be using Azure.
2012년 6월 12일 화요일 오전 1:47
I agree - this feature would make SQL Azure a serious contender for highly scalable data warehousing in the cloud. I suppose it still is if you are only using MOLAP or ROLAP without aggregations, but for us, we definitely need indexed views for aggregations.
The sad part will be that we are probably edge cases and this feature will never be important enough for Microsoft to spend the time implementing.
2012년 6월 13일 수요일 오후 12:36"Edge cases" are tomorrows scramble to implement mainstream feature.