问题描述
我们对将系统迁移到SqlServer 2014时的优异性能感到兴奋。我的团队的一个问题涉及我们目前使用索引视图来实现高读取和写入行为。您是否会详细说明SqlServer 2014中是否支持索引视图
以及是否有一种机制可以强制它们使用表中存在的MEMORY_OPTIMIZED选项进行内存优化？如果不支持内存优化的索引视图，你会推荐一种我们应该考虑
的方法吗？
Hi, we're excited about the upside performance with moving our systems to SqlServer 2014. One question my team has involves our current use of indexed views for our high read versus write behavior. Will you elaborate on whether indexed views are supported in SqlServer 2014 and whether there is a mechanism to also force them be memory optimized with the MEMORY_OPTIMIZED option that exists with tables? If memory optimized indexed views are not supported, will you recommend an approach that we should consider instead?
推荐答案
"MEMORY_OPTIMIZED"选项可用于表和索引，但不适用于视图;请参阅
The "MEMORY_OPTIMIZED" option is available for tables and indexes, but not for views; seeMemory-Optimized Tables and Indexes
内存优化是针对"物理"的。数据虽然视图只是一个定义如何返回那些数据，因此内存优化不能应用于视图。但是当然你可以在内存优化表上创建视图。
Memory optimization is for "physical" data while a view is just a definition how to return those data, therefore a memory optimization can't apply to a view. But of course you can create views on memory optimized tables.
这篇关于SQL Server 2014是否支持MEMORY_OPTIMIZED索引视图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！