If the underlying tables are involved in merge replication or transactional replication with updating subscriptions , the 如果基础表涉及到包含更新订阅的合并复制或事务性复制,则
Rather , they derive their data from the tables on which they are based , referred to as the base tables of the views 更确切的说,他们所显示的数据来源于他们所引用的表或视图的基础表
Is commonly used in data - binding applications where a control exposes the contents of the underlying table as a view 通常用于其中的控件将基础表的内容作为视图公开的数据绑定应用程序。
Specifies that any indexed views are not expanded to access underlying tables when the query optimizer processes the query 指定查询优化器处理查询时,不扩展任何索引视图来访问基础表。
To modify data in the underlying table is controlled by setting one of three boolean properties of the 通过设置dataview的三个布尔值属性之一,可以控制使用dataview修改基础表数据的能力。
Disabling an index prevents user access to the index , and for clustered indexes , to the underlying table data 禁用索引可防止用户访问该索引,对于聚集索引,还可防止用户访问基础表数据。
A nonclustered index can be stored in the same filegroup as the underlying table , or on a different filegroup 非聚集索引可以与基础表存储在同一个文件组中,也可以存储在不同的文件组中。
This difference may be caused by rounding errors during insert , delete , or update actions on underlying tables 这种差异可能是由对基础表进行insert 、 delete或update操作时的舍入错误引起的。
Specifying keepfixed plan makes sure that a query will be recompiled only if the schema of the underlying tables is changed or if 指定keepfixed plan可确保仅当更改基础表的架构或在那些表上执行
Every proposed index is partitioned in exactly the same way as the underlying table for which the index is defined 生成的建议中,每个建议的索引都完全按定义该索引的基础表所用的方式进行分区。